sheet selection via user click (yez)
 

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.

sheet selection via user click (yez)
 

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



Yossi evenzur wrote:

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