Tommi

Sub SheetDelete()
Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True
End Sub

Gord Dibben Excel MVP

On Thu, 18 Dec 2003 16:56:34 +0200, "Tommi" wrote:

Hello!

When I want delete sheet in VBA and I don't want that warning message (are
you sure etc...) appear, how I can do that?

Thanks

BR,
Tommi