Delete Sheets and avoid Excel asking the user to confirm, using custom messages instead

You can change the default display alert parameter of Excel using:

Application.DisplayAlerts = False

don’t forget to restore the standard behavior at the end of your process:

Application.DisplayAlerts = True