View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Angie Angie is offline
external usenet poster
 
Posts: 79
Default 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?