Have VBA code accept DELETE when message appears

[Titian]

Is it possible within VBA code to supress the display and user intervention when the following message apperars

"Data may exist in the sheet(s) selected for deletion
To permanently delete the data, press Delete"

Always accept the delete option.

Thanks for your help.

 

[Richard Schollar]

Include:

Application.DisplayAlerts = False

in your code before the the line which calls the delete method.

 

[Lewiy]

Try turning off Alerts before the sheet deletion:

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

 

[Titian]

Thanks guys