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

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

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

First, you must Unprotect the sheet via ToolsProtectionUnprotect sheet.

Then..........

Select the cells you wish to unlock and FormatCellsProtection. Check
"unlocked" and OK.

Now ToolsProtectionProtect Sheet. This is mandatory!!


Gord Dibben Excel MVP

On Sun, 8 May 2005 09:00:02 -0700, "onemanhattanrebel"
wrote:

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

"onemanhattanrebel" skrev i
melding ...
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

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