Excel 2007/2010 – VBA: Turn Off – Turn On Calculation

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