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?
|