How to acknowledge a message box from VB program?
 

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

How to acknowledge a message box from VB program?
 

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

--

Vasant

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

How to acknowledge a message box from VB program?
 

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...eletethissheet

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote ...
Application.DisplayAlerts = False
Sheet1.Delete
Application.DisplayAlerts = True

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