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 :)