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
|