Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Protection Query
I have a spreadsheet which allows users to enter values, and then
automatically calculates various summaries from this. Before protecting the sheet I have Locked the cells which have formulas in them, but left the others Unlocked for data entry. This works fine until the user tries to delete an entry they have made into an Unlocked cell, at which point they receive an error message saying that the sheet is protected. As they are only trying to clear an entry that they have made, I want to allow them to do so, and can't really understand why Excel is blocking this when the cell isn't Locked. Any suggestions? Thanks. Sue |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell protection | Excel Discussion (Misc queries) | |||
Password Protection - paste to unprotected cell locks the cell | Excel Discussion (Misc queries) | |||
CELL PROTECTION | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Cell Protection | Excel Worksheet Functions |