Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lock only one cell
I'm trying to lock only one cell by first unlocking the entire sheet, then
locking only the cell, and then protecting the worksheet. However, when I do this, it locks everything. When I protect the worksheet it automatically checks "Select Locked cells, and Select Unlocked Cells". If I try to unselect unlocked cells, it also removes the select locked cells check mark. It also doesn't work when both are unselected. Anyone have any thoughts? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
How to lock a row in a spreadsheet based on the value in a cell | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |