View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mitch Powell Mitch Powell is offline
external usenet poster
 
Posts: 37
Default Turn AutoCalc off on opening file

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?