How to get rid of pop-up mesg box?

  • Thread starter Thread starter none
  • Start date Start date
N

none

I've got a macro that deletes all sheets but one. I would like to
bypass the pop-up mesg box confirming the requested deletion.

Any help is appreciated.

Thanks,
Mike
 
From Help:
Example
This example closes the workbook Book1.xls and doesn't prompt the user to
save changes. Any changes to Book1.xls aren't saved.

Application.DisplayAlerts = False
Workbooks("BOOK1.XLS").Close
Application.DisplayAlerts = True

HTH
 
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

Newbie Order-Entry Macro 1
pop-up box 1
getting rid of the "confirm delete" dialogue box when deleting a s 5
pop up box 1
calculation msg box 3
How to get a message pop up when a macro has run? 2
How can I stop a windows Media player pop up on my PC 3
How to get pi to appear in a message box when coded using VBA 0

Back
Top