| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trap Sheet Name Change
Hi Otto,
Otto Moehrbach wrote: Excel 2002, WinXP Is there any way to trap the event (fire an event macro) of a user changing a sheet tab name? The Worksheet_Change macro doesn't fire with this change. Thanks for your help. I didn't mention this in the other post, but why are you restricting the renaming of worksheets? If it's to avoid breaking existing VBA code, you could change your VBA code to use the worksheets' codenames instead of the worksheet name from Excel. For more info on codenames, see http://www.cpearson.com/excel/codemods.htm. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| How can i trap the rename event of an excel sheet? | Excel Programming | |||
| How To Trap Cell Value Change Event so determine XL calc sequence? | Excel Programming | |||
| Error trap the renaming of a sheet to an existing one | Excel Programming | |||
![Jake Marx[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
