Protecting sheet but keeping list functionality in 2003

[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

 

[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

 

[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