Automatic calculation only for the tab not for the whole excel-sheet

Hi all,

I have made a large excel sheet with a lot of tabs.
The excel-sheet is starting to get slow expecially when I put more and more tabs in it.

When I am in a tab and I am changing a cell, I dont want the excel-sheet to recalculate all the formulas in the whole excel, I only want the excel to recalculate the current tab (automaticly).

I know there is an option to set the calculation on manual, and with F9 I can manual calculate the whole excel-sheet and with shift+F9 I can calculate only the tab.
I want to use the function "shift+F9" to calculate only the current tab, but not manual but automatic.

Does someone know if it is posible and how I can activate it?

Greets,
Knoert

Thanks for your responce!!!

This could be a good solution.

I am not very familiour with VBA, I can paste your VBA-code in VBA but I dont really know where to place it.

Can you tell me where I have to place it to get it working?

Thank you! I have made a test file with it, and it works!!!

Is there a little option to add to the VBA?

The option you gave only works when the calculation is set to manual.

Is there an option that I just have the calculation set to automatic, and in the active worksheet VBA cancels the automatic calculation (without changing the setting for excel) then calculates the active sheet?

Thank you for helping me!!!

pjwithfield I solved the problem this way:

I adding the following lines to the workbook:

Private Sub Workbook_Activate()
Application.Calculation = xlCalculationManual
End Sub

Private Sub Workbook_Deactivate()
Application.Calculation = xlCalculationAutomatic
End Sub


This way, the settings wont effect other excelsheets.

If you know a better way to do it I am still interested!! ;-)