| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sheet protected but cells "cleared of all" become locked
Hi,
I have a sheet where columns headers and row labels are locked but the rest of the sheet is open for editing. However, random staff members occasionally empty a cell using |Edit|Clear|All| This also resets the protection formatting for the cell, and it becomes protected. Is there a work around or is staff education the best option? This is all in Excel 2003. Cheers, Glen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to "Find Next" text in protected cells | Excel Discussion (Misc queries) | |||
| Why Can I not "Find" data in Protected Sheet | Excel Discussion (Misc queries) | |||
| How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
| 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 | |||
Threaded Mode
