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.

thanks,

adam


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


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