Angie wrote:
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?

Hi Angie

I'm not entirely clear on what you're trying to do - you want to lock
one cell (so that it can't be changed) AND you want to prevent any
unlocked cell from being selected? On the face of it I can't see why
you'd want to do that, nor I guess can Excel which is why it's
unchecking both options.

All the cells on a worksheet are locked by default, but the lock is
only activated when Protect Sheet is selected.

If you only want one cell locked then:

Right-click the square above row 1/left of column A Format Cells
Protection tab uncheck Locked OK

Right-click the cell you want locked Format Cells Protection tab
check Locked OK

Protect the sheet Tools Protection Protect Sheet check the two
Select... boxes (apply any password) OK

You can now alter any cell bar the single, locked cell.

Regards

Steve