Deleting a Prompt Message

[LC]

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.

 

[mark]

Is there a way I can disable it?

application.displayalerts = false

 

[Ron de Bruin]

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

Try this LC