Originally Posted by GS[_2_]

garygoodguy laid this down on his screen :
I have set my workbook to manual formula calculation via File --
Options -- Formula -- calculation options -- manual. The reason is
that the workbook is very large with a number of calcs.

Now what I want to do is have only one worksheet to auto calculated,
while the rest are still manual. How can I achieve this, and in what
private sub/sub do I place the code?

I have tried worksheet("worksheet name").EnableCalculate = True
And placed it under Workbook_Open, but this doesn't work.

I'm looking for a way to have this one sheet always calculate (as
opposed to active sheet, etc) as the sheet will be hidden.

Also, when I go into the sheet code of the sheet I want to be automatic,
EnableCalculation in properties is set to True. How does this affect
thing's?

Thanks in advance

When calc is in manual mode you must execute the Calculate method to
cause calculation. This will happen for every sheet where
EnableCalculation is turned on (=True)...

Application.Calculate
OR
Sheets(1).Calculate
OR
Sheets(1).Rows(2).Calculate
OR
Sheets(1).Columns(2).Calculate
OR
Sheets("Sheet1").UsedRange.Columns("A:C").Calculat e


HTH

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion