How can I prevent calculations upon opening workbook?
If a workbook needs to be calced and calc mode is automatic Excel will calc
it upon opening it before startup macros run. So setting calc mode to
manual in Sub Workbook_Open is too late. Set it to manual before opening.
--
Jim
"Randy" wrote in message
...
I have the following macro that works great upon exiting my workbook but
how
can I modify it to prevent calculations from running whenever someone
opens
it? There are so many formulas and so much data on each sheet that if we
don't calculate each sheet manually, then we have to end task on Excel
because it will not complete the calculations.
Thanks!
Randy
Private Sub Workbook_Open()
With Application
.Calculation = xlManual
.CalculateBeforeSave = False
End With
End Sub
|