| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Events
Is there any way to trap changes in sheet index via an event?
ojv |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Events
I think you mean select a different sheet. If so, in ThisWorkbook events
there are Sheet_Activate and Sheet_Deactivate. Mike F "ojv" wrote in message ... Is there any way to trap changes in sheet index via an event? ojv |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Events
Unfortunately, there is no event for moving or renaming a
worksheet. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ojv" wrote in message ... Is there any way to trap changes in sheet index via an event? ojv |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Events
thx.
"Chip Pearson" wrote: Unfortunately, there is no event for moving or renaming a worksheet. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ojv" wrote in message ... Is there any way to trap changes in sheet index via an event? ojv |
![ojv[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
