Auto calculation off on single sheet even after saving workbook?

[babaso_tawase]

I have workbook with 3 sheets named sheet 1= Sample entry, sheet 2=monthly report, sheet 3 =names. Sheet 1 have raw data about 100000 row, sheet 2 contains lots of formulas. I don't want calculate result every time while saving. I want result once in monthly, I can do calculation by pressing F9 key.
I use below vba code in module.

Option Explicit
Private Sub Worksheet_Activate()
Worksheets("Monthly Report").EnableCalculation = False
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Application.CalculateBeforeSave = False
End Sub

It gives desired results means stops calculation.
But it applies for all sheets. I just want autocalualation off for sheet 2 upon saving file and opening file also.
If I opened other normal workbook and after that I opened this workbook VBA code not works.
If I opened this workbook first and after that other workbook. Autocalulation gets offs for all other workbooks.
Is any solution for this?

 

[Joe4]

In Excel the calculation mode is not at the worksheet level, or even the workbook level, but rather at the session level!
That means if you change the calculation mode, it affects ALL worksheets in ALL open workbooks in that Excel session.
See: How Excel determines the current mode of calculation - Microsoft 365 Apps

 

[Jeffrey Mahoney]

The only true way to prevent calculations is to value the cells. What I do is save a copy of all the formulas in a hidden row above the table. when I want to calculate, I copy the formulas down, manually calculate, then value them again. A macro is perfect for this.

 

[babaso_tawase]

Ok I understand...Is there any vba code for autoculation off for particular set of cells like a1to d11.

 

[Jeffrey Mahoney]

I know of no way to to turn off a range from calculating.
There's only a way to turn off a sheet calculation. It will recalculate when you load the workbook, but it won't calculate during normal operations.