automated delete without question
 

Hi,

To suppress the dialogue box put the following


Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True


For more information look in the VBE help file.

Regards
Paul


"FireatHome" wrote in message
...
In VBA I delete a sheet with this command:
"ActiveWindow.SelectedSheets.Delete"

I get a msgbox where I have to "OK" to perform the delete.

Q: How to delete without the msgbox