MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Delete Sheet in VBA


Posted by Barry Ward on August 16, 2001 4:58 AM

I want to delete a sheet within a macro but don't want the 'are you sure' message box to come up. Can I override this?


Posted by Dax on August 16, 2001 5:00 AM

Use Application.DisplayAlerts=False

Regards,
Dax.

Posted by Barry Ward on August 16, 2001 5:43 AM

Excel-lent .... THNX

I know, I'm a punning imbecile :)