I have a very simple macro in an Excel sheet, to allows users to recalculate.
I have no other macros/code in the workbook, and only this work book open
Sub Calculate() Calculate End Sub
This is activated by a button.
However, when pressed I get two error boxes, see image.
I have looked on this website:
It says I may have too many funtions ?? This macro used to work fine, and it is hardly doing a lot so cannot understand the issue.
I am able to calculate the sheet using the option under the formulas tab.