Calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to set Excell to automatically update calculations is most
workbooks, but be set as manual in others?
 
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
 
Back
Top