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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automatically deleting a worksheet (without warning prompt) 3
Delete Worksheets in same excel 4
Delete Sheet w/o warning prompt... 6
Application.EnableEvents = False not working 2
Removing confirmation POP from excel 4
Message prompt in VBA 4
Delete a code 2
Deleting Sheets - Without a prompt 2

Back
Top