MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I need to prevent my users from manually deleting rows

Posted by adam on May 21, 2001 5:58 AM

I have a situation where all the data on a front sheet ( that the users see) if referencing certain cells on a back sheet. I have to make sure the user does not delete a row manally becuase that would screw up the references row. I have a button to delete row (which deletes the front and back sheet) but nothing is preventing the user from deleting the row manually.



Posted by Tuc on May 21, 2001 6:39 AM

Protect the worksheet will prevent the user from inserting (or deleting) rows or columns.