Deactivaion of recalc on load
Place this in the ThisWorkbook object in the on Open event:
Application.Calculation = xlCalculationManual
and in the Before Close Event
Application.Calculation = xlCalculationautomatic
--
If this posting was helpful, please click on the Yes button.
Regards,
Michael Arch.
"Michael Hoffmann" wrote:
Hi Excel experts,
is there a way to deactivate the recalculation of all Excel sheet cells when a file is loaded, even if recalculation is set to
"automatic" in the loaded sheet's options?
Thanks!
Michael
|