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.