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
and![]()
Application.EnableEvents = False
but they do not stop the functions. Are there any suggestions that may help.![]()
Application.Volatile False
Thankyou
Peter
Bookmarks