| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off Autocalc before opening sheet | Excel Discussion (Misc queries) | |||
| How come the spreadsheet says calc when it is set to autocalc | Excel Discussion (Misc queries) | |||
| Turn AutoCalc off on opening file | Excel Programming | |||
| autocalc to complicated to turn off | Setting up and Configuration of Excel | |||
| turn off autocalc | Excel Programming | |||
Threaded Mode
