Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect only part of a worksheet
How do you go about protecting only part of a worksheet?
I need to protect the top part of one of my worksheets but from what I can see I can only protect the entire thing. I find this a little strange..I'm sure there's a way...I'm just not enlightened enough :) thanks Pabs --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect only part of a worksheet
Pabs,
You can protect the entire worksheet, but leave certain cells / ranges unlocked. From the Format menu, Cells, Protection, Locked. Rob "pabs " wrote in message ... How do you go about protecting only part of a worksheet? I need to protect the top part of one of my worksheets but from what I can see I can only protect the entire thing. I find this a little strange..I'm sure there's a way...I'm just not enlightened enough :) thanks Pabs --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect only part of a worksheet
hummm
well. if I protect my worksheet when I click on the "Format" menu it doesn't give the option to select "Cell..." and if the worksheet is NOT protected and I click on a cell and format it to protected, it says I have to protect the entire sheet in order for that to work,,,,, so , unleess I'm missin something...that would not work.... --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect only part of a worksheet
You can only changed the "lockedness" of a cell when the worksheet is
unprotected. So tools|protection|unprotect sheet Then lock (or unlock) your cells then reprotect the worksheet. "pabs <" wrote: hummm well. if I protect my worksheet when I click on the "Format" menu it doesn't give the option to select "Cell..." and if the worksheet is NOT protected and I click on a cell and format it to protected, it says I have to protect the entire sheet in order for that to work,,,,, so , unleess I'm missin something...that would not work.... --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
protect only part of a worksheet
ahhh....
now I get it! you unlock the cells first and then you protect the worksheet!! I was trying to do it but not in that order..and it just would not work!! thanks Pabs --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Track Changes to protect just part of a document | Excel Discussion (Misc queries) | |||
Protect part of pivot table | Excel Discussion (Misc queries) | |||
calculate a part of a worksheet | Excel Worksheet Functions | |||
copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
Locking Part of a Worksheet/Tab | Excel Discussion (Misc queries) |