All right, this is a very simple macro.
Sheets("Sheet3").Select
ActiveWindow.SelectedSheets.Delete
However, right after I run this macro, a prompt appears:
"Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete."
Is there a way to remove this dialog box by adding an automatic reply for this prompt?
I am 100% sure that it is perfectly safe to delete it.
Sheets("Sheet3").Select
ActiveWindow.SelectedSheets.Delete
However, right after I run this macro, a prompt appears:
"Data may exist in the sheet(s) selected for deletion. To permanently delete the data, press Delete."
Is there a way to remove this dialog box by adding an automatic reply for this prompt?
I am 100% sure that it is perfectly safe to delete it.