Calculate Active Sheet Automatically

[douwek]

Dear all,

I have build a model in excel with several tabs of reference data and one cover sheet to run scenarios.
When I run a new scenario, I copy the blank cover sheet and rename it. This results in numerous tabs (25+) with different scenarios.

The question:
I want excel to automatically calculate the 'active' scenario sheet in real-time (so no F9 or Shift+F9 required), without recalculating all previous scenarios and reference files. This for performance proposes.

In other words; "How can I put the active sheet on 'automatic', without calculation the entire workbook".

I am sure it can be done with some VBA, but I am complete clueless how to use it.... so a simple step-by-step plan would be highly appreciated.

[Alf]

Have you checked the "EnableCalculation = True" and the "EnableCalculation = False" property that can be set for a sheet.

As far as I understand its reliability is not 100 % so perhaps this would work better?

Please Login or Register  to view this content.

Both codes are needed probably best to use it in "ThisWorkbook" or you could put it in the different sheets. So when you enter (activate) a worksheet calculation get set to automatic and when you switch to another sheet the calculation in the sheet you left is set to manual.

Alf