ExcelBanter - Stop Automatic Calcualation

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Stop Automatic Calcualation (https://www.excelbanter.com/excel-programming/427382-stop-automatic-calcualation.html)

Elton Law[_2_]

Stop Automatic Calcualation

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

OssieMac

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

Mike H

Stop Automatic Calcualation

Hi,

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

Mike

"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

OssieMac

Stop Automatic Calcualation

Hi again Elton,

You should also look up EnableCalculation in Help.

--
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

All times are GMT +1. The time now is 07:09 AM.