Deleting a tab without getting message pop-up

[chadski778]

I am trying to delete a worksheet in my workbook using VBA but I keep getting a message popping up saying 'Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press delete. Is there a way I can stop this message popping up?

Thanks

 

[Smitty]

You can use Application.DisplayAlerts = False at the beginning of the code. Just make sure to set it back to True at the end.

HTH,

 

[chadski778]

Thank you