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