Turn AutoCalc off on opening file

[Guest]

I need to turn AutoCalc off when a user opens the workbook. I've tried the
following to methods:

Sub Auto_Open()
Application.Calculation = xlCalculationManual
End Sub

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

In both cases, if AutoCalc is already on, the workbook calculates before
these routines are run. Any suggestions?

 

[Guest]

All I can think of is to change sub Auto_Open() to Sub Auto_Close()

This way the autocalc will be disabled before the workbook closes. And will
be disabled when next it is opened.