Thread: Worksheet name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xlcharlie xlcharlie is offline
external usenet poster
 
Posts: 37
Default Worksheet name

Anybody know some event code I could use to execute should a user try to
change the name of a worksheet? I wrote a macro that won't work if it gets
lost in the workbook (if someone changes the worksheet names) so I want to
somehow protect the current names. I tried worksheet_change, but that only
seems to execute if a cell in the worksheet is changed. Thanks.