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/

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/

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/

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

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/