sheet selection via user click (yez)

[Yossi evenzur]

Hi
what is the correct syntax for selection a sheet by the user via mouse
click? the user click on the selected sheet as the input for the macro.

 

[Dave Peterson]

Maybe a worksheet event:

Private Sub Worksheet_Activate()
'your code here
End Sub

or

A workbook event:
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
'your code here
End Sub