Protection Issue

[Mike H.]

I had a spreadsheet that someone else created that was protected. I don't
remember exactly what I did but I copied the text and now I wish to protect
just parts of it. The parts I wish to allow users to edit are working fine,
but some of the rest of the sheet, which SHOULD be protected, are not
protected. Does anyone have an idea how to fix this? Only 3 ranges are set
to allow users to edit ranges, but SOME cells outside those ranges are not
being protected. Ideas?

 

[Charlie]

Select the entire sheet. Format-->Cells-->Protection and click the "Locked"
check box until you get a check mark. Ok. Now select each range and go back
and unlock only those ranges. Then protect the worksheet.

 

[Otto Moehrbach]

Mike
There is a condition of a cell that is referred to as Locked or
Unlocked. When you protect a sheet, only the Locked cells will be
protected. Do this:
Select the whole sheet. You do this by clicking on the little square that
is above the "1" of row 1 and to the left of the "A" in Column A.
Click on Format - Cells - Protection.
Make sure that the LOCKED checkbox is checked BLACK, not gray.
Now ALL the cells are Locked.
Now select only those cells in which you want to permit editing.
Click on Format - Cells - Protection and UNLOCK those cells.
Now protect the sheet and see what you have. HTH Otto

 

[Mike H.]

That solved my problem. Thanks!

Select the entire sheet. Format-->Cells-->Protection and click the "Locked"
check box until you get a check mark. Ok. Now select each range and go back
and unlock only those ranges. Then protect the worksheet.