Deactivaion of recalc on load

  • Thread starter Michael Hoffmann
  • Start date
M

Michael Hoffmann

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
 
M

Michael

Place this in the ThisWorkbook object in the on Open event:

Application.Calculation = xlCalculationManual
and in the Before Close Event
Application.Calculation = xlCalculationautomatic
 

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
How do I run code on startup before Excel re-calculates formulas? 7
Force Recalc 3
How do I stop a recalculation in Excel? 6
Calculation slowdown at the bottom of worksheet 5
showlevels is very slow 3
stop automatic recalulation when error occurs 1
Excel Recalc All except one sheet 0

Top