| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
| Excel Program Error - Excel.exe Generated Errors Message | Setting up and Configuration of Excel | |||
| merging excel program with tdc finance program | Excel Programming | |||
| message box program flow | Excel Programming | |||
| message box program flow | Excel Programming | |||
Linear Mode
