VBA Bypass Delete Sheet Warning

[Guest]

Friends,

I have written VBA code that loops through 150 workbooks and performs
various tasks on each workbook. One task I need to perform is deleting one
sheet in each workbook.

Problem is, the Excel Delete Sheet Warning message box appears before each
deletion, which means I need to manually confirm the deletion 150 times. Is
there a VBA way to turn off Excel's delete sheet warning (like there is in
Access)?

Thanks for your help ...

bill morgan

 

[Gary Keramidas]

something like this

Sub delsheet()

Application.DisplayAlerts = False
Worksheets("sheet3").Delete
Application.DisplayAlerts = True
End Sub

 

[Guest]

application.displayalerts = false
sheets("Whatever").Delete
application.displayalerts = true

 

[Ron de Bruin]

Hi Bill

You can use this

Application.DisplayAlerts = False
'Code
Application.DisplayAlerts = True

 

[davesexcel]

Sub ..
Application.DisplayAlerts = False
'your code here ...
Application.DisplayAlerts = True
End Su

 

[Guest]

Excellent. Thank you, Jim ...

application.displayalerts = false
sheets("Whatever").Delete
application.displayalerts = true

 

[Guest]

So simple! Thanks, Gary ...

something like this

Sub delsheet()

Application.DisplayAlerts = False
Worksheets("sheet3").Delete
Application.DisplayAlerts = True
End Sub

 

[Guest]

Thanks, Dave. Glad I asked ... so simple, but would have taken me awhile to
figure out.

 

[Guest]

Thanks, Ron. Everybody giving me the same answer, so must be the BEST way ...