sheet selection via user click (yez)

  • Thread starter Thread starter Yossi evenzur
  • Start date Start date
Y

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.
 
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
 
Back
Top