Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection Issue
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection Issue
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection Issue
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." wrote in message ... 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protection Issue
That solved my problem. Thanks!
"Charlie" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protection Issue | Excel Discussion (Misc queries) | |||
Protection & Locked issue | Excel Discussion (Misc queries) | |||
Cell Protection Issue | Excel Discussion (Misc queries) | |||
Cell Protection Issue | Excel Worksheet Functions | |||
protection issue | Excel Worksheet Functions |