Freezing sheet names
 

Is there a way to freeze sheet names so users can not
change them? Thanks

Freezing sheet names
 

Protecting the workbook structure will do that (Tools, Protect, Protect
Workbook).

If you're asking because you want Workbooks("ABC") to always be valid, you
can use the sheet's "codename" which the user cannot change. A sheet's
codename is found in the Project Explorer.

--
Jim Rech
Excel MVP
"JT" wrote in message
...
| Is there a way to freeze sheet names so users can not
| change them? Thanks