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

Hi

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?

HTH

Jacob

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

Hi

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.

Jacob