I have a data list on a worksheet. As the list has various formulas in it I want to protect it but every time I do so it stop users from being able to add extra records to the list by typing in the row starting with an asterix.

I've tried selecting every option on the protect box and I've tried asking sure some cells are unprotected still no joy.

Does anyone know a work around? I'm using 2003

Thanks

Phill