automatic/manual calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone,
this is my problem..
i want to enable automatic calculation for a specific sheet in a workbook and keep calculation in all other sheets manually.
 
Try
Worksheets("name of sheet x1").EnableCalculation = False
and Worksheets("name of sheet x2").EnableCalculation = Tru
 
setting enablecalculation to false for a sheet prevents both automatic and
manual calculation from calculating the sheet. You have to toggle back to
true to calculate it.

Also the enablecalculation setting is not remembered when you save and
reopen the workbook.

(FastExcel V2 has a more user-friendly implementation of this called "Mixed
Mode Sheets").
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
 
Back
Top