Disable recalulcation upon open

[TY]

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

Thanks.

Teresa

 

[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.

 

[TY]

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

Thanks.

Teresa

 

[Julian Milano]

Set the calculation to manual. In the Workbook_Open, set it back to Auto!