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
|