MrExcel.com - Your One Stop for Excel Tips & Solutions

Suppressing Dialog Boxes During A Macro Run

Posted by Jon Griggs on August 02, 2001 3:48 PM

After this line is run, I get a delete confirmation box. How do I automatically agree to delete this sheet, without thw dialog box?

ActiveWindow.SelectedSheets.Delete

Thanks,
Jon Griggs

Posted by gregc on August 02, 2001 3:56 PM

Application.displayalerts = false

near the end of the macro insert the same but with true. If you don't do this you won't get alerts anymore.