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

Automatically Click OK during macro?

Posted by Chris on November 06, 2001 6:52 AM

I'm trying to write a macro where it deletes sheets from a specified file - how do I make Excel answer YES when it asks if I want to permanently delete the sheets?

Thanks

Posted by Dank on November 06, 2001 6:56 AM

Put Application.DisplayAlerts=False at the start of your code.

Regards,
Dan.

Posted by chris on November 06, 2001 7:02 AM

Thanks very much!