Deleting a Prompt Message
 

Hi,

How can I delete a sheet from excel file w/o having to
click 'ok' on the confirmation message? Is there a way I
can disable it?

Thank you.

Deleting a Prompt Message
 

Is there a way I can disable it?

application.displayalerts = false

Deleting a Prompt Message
 

Application.DisplayAlerts = False
ActiveSheet.Delete
Application.DisplayAlerts = True

Try this LC


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"LC" wrote in message ...
Hi,

How can I delete a sheet from excel file w/o having to
click 'ok' on the confirmation message? Is there a way I
can disable it?

Thank you.