Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protect Workbook
I keep reading the Excel Help and rubbing my eyes and looking at Excel and
rubbing my eyes some more . . . I need to prevent users from changing the names of my worksheets. I have a few formulas that "hard code" sheet names inside INDIRECT formulas, so any change to the sheet names causes a Ref# error. When I looked in Help it says the following: On the Tools menu, point to Protection, and then click Protect Workbook. To protect the structure of a workbook so that worksheets in the workbook can't be moved, deleted, hidden, unhidden, or renamed, and new worksheets can't be inserted, select the Structure check box. I see no such menu option in Excel 2003. There is something about Worksheet Sharing, but not the basic protection features described in Help. There has to be a way - besides some type of VBA workaround - to prevent users from changing the names of worksheets, right? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect on column from a workbook | Excel Discussion (Misc queries) | |||
Protect Workbook Vs Protect Sheet | New Users to Excel | |||
Protect Workbook | Excel Discussion (Misc queries) | |||
Protect Workbook | Excel Discussion (Misc queries) | |||
protect a workbook from being deleted | Excel Discussion (Misc queries) |