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


"Doug Glancy" wrote in message
...
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