Deactivaion of recalc on load
 

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

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