How do I override a deletion box?

[DMuehl]

This is the message I receive.

Data may exists in sheet(s) selected for deletion. To permantel
delete the data press delete.

The macro stops the loop process for this question with every build.
need it to be deleted automatically and build the next one.

Thank you :confused

 

[Guest]

hi,
try add something like this:
Application.DisplayAlerts = False
Worksheets("Report").Delete
Application.DisplayAlerts = True

 

[Guest]

Try this:

Application.DisplayAlerts = False

' Your code

Application.DisplayAlerts = True