You may want to add a Workbook_Open event that turns off Calculation and a
Workbook_CLose event that turns it back on. Of course, if you have other
workbooks open at the same time, you won't be able to do any calculations
unless you do them manually.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



"Tenacity9" wrote:

Setting Tools-Options-Calculation to manual (ie, have to use F9) changes the
preference for all open workbooks in Excel 2003.

If you only want manual recalculation to apply to a particular workbook
permanently (in other words until the preference is changed back to
automatic), but other open workbooks and all new workbooks to be calculated
automatically (ie, no F9), is there a way to accomplish this easily?

Thanks.