Josh

Since Excel takes the calculation mode from the first workbook opened during a
session, the only sure way to set calculation mode for a particular workbook
would be through code that runs when a workbook is opened or activated.

Private Sub Workbook_Activate()
Application.Calculation = xlCalculateManual
Application.Calculation = xlCalculationAutomatic
End Sub

Private Sub Workbook_Open()
Application.Calculation = xlCalculateManual
Application.Calculation = xlCalculationAutomatic
End Sub


Gord Dibben Excel MVP




On Mon, 14 Feb 2005 13:55:14 -0800, "Josh O."
wrote:

Is there a way to set Excell to automatically update calculations is most
workbooks, but be set as manual in others?