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
 
Top