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?

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

Mike F

"Ken Loomis" wrote in message
...
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?

Thanks. That worked great.


"Mike Fogleman" wrote in message
...
Application.DisplayAlerts = False
Sheets("Replace Info").Delete
Application.DisplayAlerts = True

Mike F

"Ken Loomis" wrote in message
...
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?

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...


"Mike Fogleman" wrote:

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

Mike F

"Ken Loomis" wrote in message
...
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?

Ken

Surround with

Application.DisplayAlerts = False

Sheets("Replace Info").Delete

Application.DisplayAlerts = True


Gord Dibben Excel MVP

On Thu, 24 Mar 2005 14:38:05 -0800, "Ken Loomis" wrote:

I am using this to delete a worksheet:



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