VBA: Turn Off – Turn On Calculation

October 31st, 2004 | Categories: VBA | Tags:
-->

You can turn off automatic calculation with a macro by setting it to xlmanual. Use the following piece of VBA code:

Application.Calculation = xlManual

To turn on automatic calculation from VBA:

Application.Calculation = xlAutomatic
Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. Tim Noyes
    July 25th, 2009 at 16:33
    Reply | Quote | #1

    If the above doesn’t work for you (it didnt for me) try

    Application.Calculation = xlCalculationManual

    ..

    Application.Calculation = xlCalculationAutomatic