Stop Automatic Calcualation

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
 
O

OssieMac

Hi Elton,

'Turn off Auto Calculate
Application.Calculation = xlCalculationManual

'Turn on Auto Calculate
Application.Calculation = xlCalculationAutomatic
 
M

Mike H

Hi,

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

Mike
 
Top