disabling custom function

[rgandy]

All,
I have a spreadsheet in which I use some somewhat time consuming custom functions...
couple of questions
a) are there particular methods for optimizing custom functions? those that microsoft provides seem to run exponentially faster and i am wondering if there is any way to at least partially mimic their methods

more importantly,
b) is there a way to disable custom functions temporarily via code? i have an iteration calculation that requires sheet recalculation (but not the recalculation of the custom functions)...is there any way to get this functionality active in a workbook (not constant refresh of custom functions) thanks

 

[macropod]

Hi rgandy,

Whether and how a given custom function might be optimized really depends on the function itself. Perhaps if you post the code and a description of what it does, some hints could be given.

Cheers

[MS MVP - Word]