Is there a way I can set the "Calculation" to manual for only specified
workbook?

Yes, you can use a Workbook Open Event macro.
--
Gary''s Student
gsnu200710


"nc" wrote:

Is there a way I can set the "Calculation" to manual for only specified
workbook?

This may not be simple if you ever have more than 1 workbook open at a time.

Calculation mode is an Excel Application level property so its always the
same for all the currently opened workbooks: you cannot easily Mix
calculation modes for open workbooks.

The current application setting is stored in a workbook when it is saved.

Excel sets Calculation mode from the first workbook opened: if you open a
workbook that was saved in automatic mode and then another workbook that was
saved in manual mode both workbooks will be in automatic mode.

If you use the Workbook_Open or Auto-Open events to change calculation mode
this will not neccessarily prevent an initial calculation when the workbook
is opened because the calculation is done before the Open event is fired.


Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"nc" wrote in message
...
Is there a way I can set the "Calculation" to manual for only specified
workbook?