Disable recalulcation upon open

T

TY

Is there anyway in a macro that I can disable recalculation of UDF upon
opening a workbook in automatic calculation mode?

Thanks.

Teresa
 
J

Julian Milano

Sure. In the Workbook_Open event, set a variable to True. In the UDF, test
if the same variable is TRUE, if so, exit the UDF.
 
T

TY

Hi Julian,
That will not work. In automatic calculation mode, Workbook_Open event
happens after UDF being invoked.

Thanks.

Teresa
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

controlling excel recalculation in VBA? 5
Set Calculation Mode to Automatic without calculating 2
How to avoid recalulcation (UDF)? 2
UDF not returning proper value - circular reference/multi workbook 1
Turn AutoCalc before calc takes place 5
Recalculation upon opening a workbook 4
Turning Automatic Calculation On after Workbook loads 4
Display the current value of an Options setting 4

Top