Stop Automatic Calcualation

  • Thread starter Thread starter Elton Law
  • Start date Start date
E

Elton Law

Hi All,
I know VB script "Calculate" will force to run calculation on the sheet.
How to stop the automatic calculation on the sheet in VB script please ?
Thanks
 
Hi Elton,

'Turn off Auto Calculate
Application.Calculation = xlCalculationManual

'Turn on Auto Calculate
Application.Calculation = xlCalculationAutomatic
 
Hi,

Application.Calculation = xlCalculationManual
'do things
Application.Calculation = xlCalculationAutomatic

Mike
 
Back
Top