calculation in a worksheet

[Guest]

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

 

[Zone]

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

 

[RagDyeR]

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

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