Delete a Sheet without dialog

[Ken Loomis]

I am using this to delete a worksheet:

Sheets("Replace Info").Delete

however, that causes a warning dialog box. How can I delete that worksheet
without a dialog box?

 

[Mike Fogleman]

Application.DisplayAlerts = False
Sheets("Replace Info").Delete
Application.DisplayAlerts = True

Mike F

 

[Gord Dibben]

Ken

Surround with

Application.DisplayAlerts = False

Sheets("Replace Info").Delete

Application.DisplayAlerts = True


Gord Dibben Excel MVP

 

[Ken Loomis]

Thanks. That worked great.

Application.DisplayAlerts = False
Sheets("Replace Info").Delete
Application.DisplayAlerts = True

Mike F

 

[Jim Thomlinson]

Just to be safe you should probably add

Application.DisplayAlerts = False
on error resume next
Sheets("Replace Info").Delete
Application.DisplayAlerts = True

or add this line into an existing error handler if you have one
Application.DisplayAlerts = True

Otherwise if the delete fails then you never turn the alerts back on whcih
can be a bad thing...