My worksheet contains several custom functions. The functions calculate, as usual, when data is entered. How do I prevent the functions from recalculating while a macro is running? The macro carries out calculations as well, and each time data is entered by the macro the functions recalculate. I have tried
Application.EnableEvents = False
and
Application.Volatile False
but they do not stop the functions. Are there any suggestions that may help.
Thankyou
Peter