[RESOLVED] Auto-confirm deletion of spreadsheet during runtime

[Daniel McCool]

I load a spreedsheet during runtime, and delete it during runtime. The only problem is that the message box comes up asking me to confirm the delete. I don't want my users to have to see this and click it. Is there a way to remove the spreedsheet without having the user to click anything?

[RobDog888]

Yes.

Application.DisplayAlerts = False
Worksheets("Sheet3").Delete
Application.DisplayAlerts = True