View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default 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/