View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Sheet name change

You could protect the workbook.
Alternatively, if the problem with the changing sheet names is related to
referencing the sheets in VBA, use the sheet codename instead.

Eg:

Sheet1.Range("A1")
instead of
ThisWorkbook.Sheets("Sheet1").Range("A1")

Tim.

--
Tim Williams
Palo Alto, CA


"spacecityguy"
wrote in message
news:spacecityguy.225uon_1138142404.8435@excelforu m-nospam.com...

Is there a way to detect sheet name changes or prevent user from
changing the name of a sheet? Thanks.


--
spacecityguy
------------------------------------------------------------------------
spacecityguy's Profile:

http://www.excelforum.com/member.php...o&userid=11060
View this thread: http://www.excelforum.com/showthread...hreadid=504683