Confirm deletion

D

dsan

Worksheets(1).Select
ActiveWindow.SelectedSheets.Delete

When deleting a sheet from my workbook using the above code I am asked
to confirm that I really want to do this. How can I force the macro to
delete without requiring confirmation?
 
H

Harald Staff

Hi

Simplify. Dont select and use their windows. Just delete Worksheets(1).

What you look for is DisplayAlerts, set it to False and it means "I know
what I'm doing so don't interrupt". Like this:

Sub Killit()
Application.DisplayAlerts = False
Worksheets(1).Delete
Application.DisplayAlerts = True
End Sub
 
Top