Jagat Pavasia
Active Member
- Joined
- Mar 9, 2015
- Messages
- 359
- Office Version
- 2021
- Platform
- Windows
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 :
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.
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 :
VBA Code:
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.