How to acknowledge a message box from VB program?

[Darwin]

When deleting a sheet from VB program a message box pops
up and waits for acknowedgement. How can I
programmatically acknowledge (close) the box?

 

[Vasant Nanavati]

Application.DisplayAlerts = False
Sheet1.Delete
Application.DisplayAlerts = True

 

[David McRitchie]

An example of code to delete the sheet w/o verification when
- Sheetname begins with "sheet", and
- There is no code in the sheet (no Worksheet Event macros)

Delete Active Sheet if name begins with "sheet" (#DeleteThisSheet)
Worksheets in VBA Coding and in Worksheet Formulas
http://www.mvps.org/dmcritchie/excel/sheets.htm#deletethissheet