Deleting a Prompt Message

LC · Jul 18, 2003

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 · Jul 18, 2003

Is there a way I can disable it?

application.displayalerts = false

Ron de Bruin · Jul 18, 2003

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

Try this LC