Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freezing sheet names
Is there a way to freeze sheet names so users can not
change them? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freezing Sheet Tab | Excel Discussion (Misc queries) | |||
Cell names = sheet names | Excel Worksheet Functions | |||
How do I delete all names ranges in a workbook after freezing form | Excel Discussion (Misc queries) | |||
Freezing multiple panes on 1 sheet | Excel Discussion (Misc queries) | |||
return all worksheet tab names and chart sheet tab names in report - an example | Excel Programming |