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

Application.DisplayAlerts = False 'at the beginning of module
Application.DisplayAlerts = True 'at end of module

Amit


"Tommi" wrote in message
...
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

Use:

application.displayalerts = false
'Delete Sheet
application.displayalerts = true

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