Code to select "Delete" when deleting a tab within a Macro

Hello, is there a way to delete a tab during a macro? In the attached sample for example, when a tab is deleted via code, the message box pops up despite clicking the "delete" button while recording the macro. Is there a way to code the delete button being selected so the macro is not interrupted with the message box?

Thanks so much.
Sheryl

Hello Sheryl,

If you are referring to the warning message that pops up asking you to confirm whether or not you wish to proceed with the sheet deletion, then you would only need to modify the code as follows:-

Please Login or Register  to view this content.

This will suppress the pop up.

I hope that this helps.

Cheerio,
vcoolio.

Thank you!

You're welcome Sheryl,

Glad that we were able to help and thanks for the rep.

Cheerio,
vcoolio.