Difficult protection request

[Siberian]

I have a sheet in which I want to protect certain cells from being changed, but the user still needs to able to insert new rows. Of course, deleting my "original" rows is out of the question, but they may delete their own inserted rows as they wish. Is there any way this can be done??

[Mallycat]

Not without some VBA code. You would have to trap the insert events, unlock the spreadsheet, insert the rows and then lock it again. You would also need to keep a record of which rows has been inserted so you could determine if they are allowed to delete them.

Matt