calculation when i click to sheet2

[Jagat Pavasia]

hello, how are you all ??

I have workbook with 2 sheet. I have turned calculation method from auto to manual from formulas menu.

and now i have put macro in sheet1 VBA code Below :

       Private Sub Worksheet_Change(ByVal Target As Range)
Me.Calculate
End Sub

Now, i want that sheet2 is calculating only when i click on sheet2.

when i jump to Sheet1, then sheet2 calculation is turned off.


give me VBA code to put in sheet2.

 

[Fluff]

Duplicate Calculation option VBA code

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).