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 before calc takes place

It is critical that a particular workbook NOT calculate upon opening, so I
used the following:

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

The problem is that if calculation is is already in auto mode when workbook
is opened, calculation takes place before this code can run and turn it off.
Any ideas?