Protected Worksheet And Lists

C

Cuperman007

Is it possible to protect a worksheet that contains a list, and still
be able to add rows to the list? (Excel 2003)

Thanks,
Mark
 
J

Jim Rech

I never thought about it but after a few minutes poking around it doesn't
look to be possible. Even if you unlock all the cells in the sheet.

--
Jim
| Is it possible to protect a worksheet that contains a list, and still
| be able to add rows to the list? (Excel 2003)
|
| Thanks,
| Mark
 
R

Roger Govier

Hi Jim
Yes, I had also been trying various things, and there was no way I could get
it to work.
Seems to be the same in XL2007 with Tables as well, you can't add data to
the table when the sheet is protected.
 
Top