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
SOURCE | LINK | LANGUAGE | ENGLISH |