Manual Calculations questions

[ghrek]

HI

Can you set excel up so that I can do manual calculations on one workbook only?

I know how to do it on formulas tab but it sets all my excel workbooks for manual calculation and need one specific book only to have it.

Any Ideas?

 

[theBardd]

You could add the code to set that state in workbook activate, and reset in workbook deactivate

Private Sub Workbook_Activate()
    Application.Calculation = xlCalculationManual
End Sub
Private Sub Workbook_Deactivate()
    Application.Calculation = xlCalculationAutomatic
End Sub