Hello everybody
Is there any way to disable calculation of a particular sheet in a
workbook? I would like the calculation option for the workbook to be
automatic.
With regars
Sridhar

You can do it the other way around. Set the calculation to manual, then
calculate range(s) in the sheet like this:
Sub Test()
Range("c1:c85").Calculate
End Sub
HTH, James
"yshridhar" wrote in message
...
Hello everybody
Is there any way to disable calculation of a particular sheet in a
workbook? I would like the calculation option for the workbook to be
automatic.
With regars
Sridhar

NON-code option:

Set WB to manual.

To calculate *only* the active sheet:
<Shift <F9
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Zone" wrote in message
...
You can do it the other way around. Set the calculation to manual, then
calculate range(s) in the sheet like this:
Sub Test()
Range("c1:c85").Calculate
End Sub
HTH, James
"yshridhar" wrote in message
...
Hello everybody
Is there any way to disable calculation of a particular sheet in a
workbook? I would like the calculation option for the workbook to be
automatic.
With regars
Sridhar