LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 158
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Protect on column from a workbook hoachen Excel Discussion (Misc queries) 1 September 13th 06 03:12 AM
Protect Workbook Vs Protect Sheet Poor_pakistani New Users to Excel 4 May 25th 06 02:06 PM
Protect Workbook Pedro Mestre Excel Discussion (Misc queries) 1 April 6th 06 03:49 PM
Protect Workbook Daniel Excel Discussion (Misc queries) 3 October 12th 05 08:27 PM
protect a workbook from being deleted Toni's Taxi Excel Discussion (Misc queries) 1 January 12th 05 07:38 PM


All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"