Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping calculation on workbook open
Hi,
I have put the following code in both the Sub Auto_Open() and Private Sub Workbook_Open() procedures Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.EnableCalculation = False Next ws However, when I open the workbook I still see the status bar indicating that the the workbook is recalculating. Now besides putting code into the status bar :-) what am I doing wrong? Why is the workbook still recalculating? Regards, Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping calculation on workbook open
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stopping calculation on workbook open
The problem is that Excel does the Calculate BEFORE any event such as
Workbook_Open fires. The only way to prevent the calculate is to make sure Excel is in Manual calculation mode before the workbook is opened. Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com wrote in message ups.com... Hi, I have put the following code in both the Sub Auto_Open() and Private Sub Workbook_Open() procedures Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.EnableCalculation = False Next ws However, when I open the workbook I still see the status bar indicating that the the workbook is recalculating. Now besides putting code into the status bar :-) what am I doing wrong? Why is the workbook still recalculating? Regards, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stopping Auto calculation in Part of a Worksheet | Excel Worksheet Functions | |||
Stopping Calculation | Excel Discussion (Misc queries) | |||
Stopping a workbook updating | Excel Discussion (Misc queries) | |||
Stopping calculation once it starts | Excel Discussion (Misc queries) | |||
Stopping chart line where 1 of 2 columns of data in calculation is blank | Charts and Charting in Excel |