A macro I use deletes a sheet tab, however, it prompts me to confirm
the deletion of the sheet. How can I remove this prompt so the macro
runs without any user interaction?
I think you can use this:
Application.DisplayAlerts = False
Add these 2 lines to your macro:
Application.Displayalerts = False '<<<< here
Application.Displayalerts = True ' <<< and here
Both answers worked, thank you very much.