How do I unlock specific cells in a spreadsheet that I protected?

  • Thread starter onemanhattanrebel
  • Start date
O

onemanhattanrebel

I have a spradsheet that I protected and I now want to unlock some specific
cells so my users can update the cells. I tried to do this by going to Format
then Cells and so on, but when I clicked on the Format tab then on the Cell
option, the cell option is grayed out(not active). What is causing this and
is there a work around?....Tks, MM
 
G

Gord Dibben

By default all cells are locked when the sheet is protected.

First, you must Unprotect the sheet via Tools>Protection>Unprotect sheet.

Then..........

Select the cells you wish to unlock and Format>Cells>Protection. Check
"unlocked" and OK.

Now Tools>Protection>Protect Sheet. This is mandatory!!


Gord Dibben Excel MVP
 
H

Harald Staff

onemanhattanrebel said:
I have a spradsheet that I protected and I now want to unlock some specific
cells so my users can update the cells. I tried to do this by going to Format
then Cells and so on, but when I clicked on the Format tab then on the Cell
option, the cell option is grayed out(not active). What is causing this and
is there a work around?....Tks, MM
Click to expand...

That is because you protected the sheet before before you tried to unlock
the cells.

The workaround would be to unprotect the sheet, then unlock the cells, then
protect the sheet.

HTH. Best wishes Harald
 
Top