What Application Events fire on a Sheet name change?

BrighterLater

Board Regular
Joined
Sep 16, 2005
Messages
112
Please can you tell me what Application Events fire when I rename a sheet?
I was expecting Sheetchange to fire but it does not seem to
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
There are none, as far as I know.

The SheetChange event is for changes in the cells on that sheet, not the sheet name itself.
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
<strike>AFAIK, Kristy is correct, no events fire when sheets get renamed. You'd have to create a static or module-level array of sheet names and compare it during some other event like SheetSelectionChange or SheetActivate and so forth.</strike> {...nevermind - Tom's got it covered...}
 

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
Ok, to specify: there are no *built in* events that will be triggered on a sheet name change. :)
 

BrighterLater

Board Regular
Joined
Sep 16, 2005
Messages
112
Thanks for all the help. The constancy of the codename property is exactly what I was looking for. I have a collection which contains an object for each sheet and each object contains several properties for the sheet. By referencing this collection by the codename I can do what I want and handle new sheets, deleted sheets and sheet name change. Many thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,118,455
Messages
5,572,235
Members
412,449
Latest member
mdvouf
Top