Disable Excel warning/message boxes
I am deleting worksheets in vba by using the line:
worksheet("Sheet2").delete
However Excel displays a warning box that it is about to delete a sheet. At which point user can presss cancel, which is not something I want user to do.
Is there any way to stop Excel from displaying the message box.
Thank you for your help. :wave:
Re: Disable Excel warning/message boxes
Application.DisplayAlerts = False
Application.DisplayAlerts = True
<Resolved> Disable Excel warning/message boxes
So easy when you know, also the easy is the first missed.
Thank you for your fast help.