How to: Automaticly choose "YES"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

One of the macro's I use makes a sheet, uses it and then deletes it. Because
there is a sheet which is deleted, Excel asks confirmation while the Macro is
running. I'd rather see that it was solved without the user has to click yes.

My question: "How can I get Excel to not ask me the "Are you Sure?" question
again?"
 
Jasper

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

Regrads

Trevor
 
Back
Top