MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Protect Row

Posted by Al Jacobs on January 18, 2002 2:35 PM

I have a spreadsheet that needs to remain unprotected, but I want to warn users if they try to dellete rows. If they try to delete a row, I want a box to pop up that says "you can't do that," then a continue button to take them back to the unmodified spreadsheet. Is this possible? Thanks.

Posted by Jacob on January 18, 2002 4:18 PM


You can unlock all the cells and then protect the sheet to stop deleting rows. Or is there another reason why you dont want to protect it?



Posted by A Jacobs on January 18, 2002 6:53 PM

I have too many macros that copy between sheets, and I wanted to avoid rewriting all of them to unprotect then protect each sheet. Plus, my users like to experiment until they get an actual warning. I was hoping there is an OnEvent property that I could use with a Delete function.

Posted by Jacob on January 19, 2002 1:45 PM


There isnt a on delete event unfortunetely. There is a worksheet change event you might play with and application.undo to undo the delete, but it would probably be more trouble than it is worth.