Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there any reliable way to detect when user switches worksheets?
My VBA needs to react when a user switches worksheets, and I have a set of event catchers (Workbook_SheetSelectionChange, Worksheet_SelectionChange, WorkSheet_Activate, WorkSheet_Deactivate) which I thought was foolproof. Whether user switched sheets via my hyperlinks, used sheet tabs, or used the Web toolbar, I got one of these events to trigger. But user can start on sheet1, use Edit/GoTo to get to Sheet2, click an option button, use Edit/GoTo to get back to sheet1, click a button all without triggerring an event. I can trap more events with the option buttons, but isn't there an easier way? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can I trap the change event (Tab Press key) of these controls | Excel Programming | |||
how can I trap the change event (Tab Press key) of these controls | Excel Programming | |||
how can I trap the change event (Tab Press key) of these controls | Excel Worksheet Functions | |||
how can I trap the change event (Tab Press key) of these controls | Excel Worksheet Functions | |||
Trap Sheet Name Change | Excel Programming |