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]