Difficult protection request

S

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??
 
M

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
 
Top