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

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

Joerg,

Sorry, I should have been more clear. I have a couple of Lists -
DataList - 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

"Joerg Mochikun" wrote in message
...
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