How to prevent users from deleting tabs

I have a template full of vlookup references which makes the file size huge. In order to reduce the file size; I have a macro set to run an integrity check and if there are no errors it copies and pastes - special all of the cells to reduce the depency on my vlookup tables. The macro then deletes the vlookup tables.

The problem is that there are 3 tabs full of these vlookup references and if the user deletes one of the tabs themselves; my macro fails because it tries to do operations on a tab that isn't there.

I can solve this one of two ways but don't know the VB code.

1. Prevent the user from being able to delete the tabs.
2. Add a step in the macro to only perform the operations on those tabs if the tab is present.

Anyone have some input on this? Any feedback is appreciated because I didn't have any luck with the search function.

Thank you both,

I think the verification to see if the sheet exists will do the trick.

Thanks!!