Deleting a Prompt Message

  • Thread starter Thread starter LC
  • Start date Start date
L

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.
 
Application.DisplayAlerts = False
ActiveSheet.Delete
Application.DisplayAlerts = True

Try this LC
 
Back
Top