Run a macro when changing the sheet
 

I would like a macro to run every time the user changes of sheet.
Not when a cell is selected or changed, but immediately after changing the
sheet.
I want it to run also when a new sheet is added to the workbook.

Thank you in advance.

Run a macro when changing the sheet
 

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)

Put your macro here

End Sub

"S. G." wrote:

I would like a macro to run every time the user changes of sheet.
Not when a cell is selected or changed, but immediately after changing the
sheet.
I want it to run also when a new sheet is added to the workbook.

Thank you in advance.

Run a macro when changing the sheet
 

Put these in ThisWorkbook

Private Sub Workbook_NewSheet(ByVal Sh As Object)
MsgBox ("New")
End Sub

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
MsgBox ("Activated :") & Sh.Name
End Sub



"Mike" skrev:



Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)

Put your macro here

End Sub

"S. G." wrote:

I would like a macro to run every time the user changes of sheet.
Not when a cell is selected or changed, but immediately after changing the
sheet.
I want it to run also when a new sheet is added to the workbook.

Thank you in advance.