View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default 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