| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select locked cells
I have several worksheets distributed to users where the formulas are in
locked cells and when I protect the sheet I always make sure that "Select Locked cells" is not ticked. One user has shown me a sheet I sent her where all the formulas are visible, even though the sheet is still protected. I unprotected the sheet on her PC and looked at her settings and she has "select locked cells" ticked. Does her setting override my setting even though the sheet was saved with the option unticked, and if so how do I overcome this? (Using Excel 2003 SP1) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect shouldn't default to "allow users to select locked cells" | Setting up and Configuration of Excel | |||
| Still can select locked cells in protected sheet | New Users to Excel | |||
| Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions | |||
| Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
| how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Threaded Mode
