Thread: Stopping calculation on workbook open
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Damien McBain[_3_] Damien McBain[_3_] is offline
external usenet poster
  
Posts: 28
Default Stopping calculation on workbook open
wrote:

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

how about

Application.Calculation = xlCalculationManual
Reply With QuoteReply With Quote