Protected Worksheet And Lists

  • Thread starter Thread starter Cuperman007
  • Start date Start date
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
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting data lists but allowing data entry 19
Excel lookup across entire workbook 1
Protect worksheet but still be able to use Data Filter and Data Sort 2
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Counting multiple memberships 1
Protect Sheet not allowing insert or delete rows. VBA buttons notsolving problem ? 1
Excel Protection 2
Excel Move or Copy Stopped Working? 0

Back
Top