Thank you very much!!


On Fri, 14 May 2010 13:34:59 -0700, Gord Dibben gorddibbATshawDOTca
wrote:

Set Calculation Options to Manual and uncheck "recalculate before save"

Add this event code to the worksheet in question.

Private Sub Worksheet_Activate()
Application.Calculate
End Sub

Only when you select that sheet will you calculate.

Note: if you open this workbook after a workbook with calculation set at
auto, this workbook will also be changed to auto-calc.

i.e. First workbook opened determines the calculation mode for subsequent
workbooks.

You have to be careful with this...................


Gord Dibben MS Excel MVP

On Fri, 14 May 2010 18:54:21 +0200, wrote:

Thank you
Is there a way to ony make this calculate when the sheet (where I use
now() ) is opened?

On Fri, 14 May 2010 10:51:05 +0800, "ozgrid.com"
wrote:

You probably have Volatile formulas within. E.g TODAY,NOW etc These formula
recalculate every time you open the file or do most things in Excel.