WORKSHEET CHANGE HANDLER

[Dan]

Hello. I want to run a function when a user clicks to view a particular
worksheet. I know a button click event would look like the following:

Sub btnMyButton_Click

End Sub

Is there a change handler that watches when a user goes to a particular
worksheet? If not, is there something similar I can use?

[NickHK]

Dan,
You have
Private Sub Worksheet_Activate()
as an event on each worksheet or
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
as an event on ThisWorknook

NickHK

"Dan" <[email protected]> wrote in message
news:[email protected]...
> Hello. I want to run a function when a user clicks to view a particular
> worksheet. I know a button click event would look like the following:
>
> Sub btnMyButton_Click
>
> End Sub
>
> Is there a change handler that watches when a user goes to a particular
> worksheet? If not, is there something similar I can use?