Thread: Stop Automatic Calcualation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
  
Posts: 2,510
Default Stop Automatic Calcualation
Hi Elton,

'Turn off Auto Calculate
Application.Calculation = xlCalculationManual

'Turn on Auto Calculate
Application.Calculation = xlCalculationAutomatic

--
Regards,

OssieMac


"Elton Law" wrote:

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
Reply With QuoteReply With Quote