How to avoid delete confirmation

  • Thread starter Jens Palacios Neffke
  • Start date
J

Jens Palacios Neffke

Hi.

I got a macro on workbook1 that deletes a sheet on workbook2. But when I
execute it, it shows a warning asking for confirmation. How can I avoid this
warning and getting the sheet deleted?

Any kinda help will be greatly appreciated

Jepane
 
J

Jim Thomlinson

Applicartion.displayAlerts = False
'Delete your sheet
Application.DisplayAlerts = True
 

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

Eliminare un fastidioso avviso di sicurezza 0
Link to Named Range in External File 0
How to erase a column VBA 2
lookup for first n characters 1
Macro to select and delete levels of a document 2
Outlook 365 delete confirmation not working even though the option is selected 1
Update values in WkBk1 from WkBk2 1
Undo jumps between multiple open workbooks 4

Top