I'm setting up a complex worksheet that is taking a long time to run, due
to
automatic calculation.

Don't know if this idea would work for you.
In the vba editor, place the following code in the worksheet module of the
worksheet you would like to have set to Manual calculations.
The idea here is that when you select your particular sheet, Calculation
will be set to manual.
When you leave the sheet, it will be set back to automatic.

Private Sub Worksheet_Activate()
Application.Calculation = xlCalculationManual
End Sub

Private Sub Worksheet_Deactivate()
Application.Calculation = xlCalculationAutomatic
End Sub


--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"Paulo A" wrote in message
...
I'm setting up a complex worksheet that is taking a long time to run, due
to
automatic calculation.

I'd like to setup Manual calculation just for this worksheet without
affecting all other open sheets. Is this possible?

Thxs!