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
VBA: Turn Off - Turn On Calculation
Leave a Comment
