To my knowledge there is no event associated with deleting a sheet (I'm sure someone will correct me if I'm wrong ). Depending on the situation, if you have a particular workbook you want to control, you could create an array listing all of the sheets that should be there, and use another event (before save?) to loop through the sheets and check that they all still exist in the workbook.