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.

"Mike H." wrote:

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?