Protecting sheet but keeping list functionality in 2003

D

Doug Glancy

I think I've asked this before a while back, but is there any way to unlock
some cells, protect the worksheet and still have a list function as normal
in terms of allowing the user to add a new row?

tia,

Doug
 
J

Joerg Mochikun

When you protect the worksheet you can allow users to insert rows (one of
the check boxes in the protection dialog). New rows inherit the lock
properties of the preceding row, so if the cells in the last row of your
list are unlocked, a newly inserted row will add unlocked cells to your
list.

Joerg
 
D

Doug Glancy

Joerg,

Sorry, I should have been more clear. I have a couple of Lists -
Data>List - on a worksheet. I'd like to be able to have the formula cells
in them and elsewhere on the sheet locked, and still have the Lists function
with the new row (the row at the bottom of the list with the "*") and Insert
Row capability.

Thanks,

Doug
 

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

Top