Tuesday, January 20, 2009

Excel - Turn off AutoCalculation with VBA Code

Public Function TurnOffAutoCalc()
Application.Calculation = xlManual
End Function

Public Function TurnOnAutoCalc()
Application.Calculation = xlAutomatic
End Function