Try

Application.Calculation = xlManual
'Do something
Application.Calculation = xlCalculationAutomatic

Mike

"Ward" wrote:

I am needing to disable 5 worksheets from being automatically calculated due
to the massive amounts of formulas each holds. I would still like for excels
default setting Auto Calculate to remain active. I have attempted to set each
sheets .EnableCalculation property to False - without luck. Any input would
be greatly appreciative, thanks!