Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
WORKSHEET CHANGE HANDLER
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
WORKSHEET CHANGE HANDLER
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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error handler | Excel Discussion (Misc queries) | |||
Error Handler | Excel Discussion (Misc queries) | |||
Worksheet Handler (int) | Excel Programming | |||
Registering an even handler | Excel Programming | |||
error handler | Excel Programming |