Thanks guys; this will definitely resolve my issues. Appreciate the help!
"Charles Williams" wrote:
Excel calculates before any events fire ...
so the onl;y way is to switch to Manual before opening the workbook ...
adding a workbook that is in Manual mode to XLStart will work.
Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com
"Paige" wrote in message
...
Yikes, I'm embarrased! Thanks, Jim. The other part was how to stop it
from
calculating when opening a file. I tried putting Application.Calculation
=
xlCalculationManual in ThisWorkbook, but it still calculates when the file
is
opened.
"Jim Thomlinson" wrote:
The before save part is easy...
Application.CalculateBeforeSave = False
I did not follow you on the first part...
--
HTH...
Jim Thomlinson
"Paige" wrote:
If I open a file that includes code (Application.Calculation =
xlCalculationAutomatic) in ThisWorkbookthat changes calc to manual upon
opening, it still calculates; likewise, if I use SaveAs in a macro,
even if I
explicitly change calc to manual first, once it starts saving, it
recalculates. How do I stop Excel from calculating when a file is
opened and
saved? P.S. Am using Excel 2003.