| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic accept all pop up dialog box
While macro is executing. how do I get VBA to automatically select either
"YES or OK whenever any dialog box pops up asking for user input? I just need VBA to automatically accept any YES as well as OK, which pops up during execution of macro. To look through & modify the macro developers code will be like impossible. Im VBA rookie. Is there a command line which I can insert at the top (after Dim statement) which can automatically accept all pop ups along execution of codes? Thanks alot -- Edmund (Using Excel XP) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Accept or Reject a value | Excel Worksheet Functions | |||
| How to delete the "Insert Function Dialog Box" (dialog box only)? | Excel Worksheet Functions | |||
| Excel: How to suppress the Names conflict Dialog on automatic VBA copy | Excel Programming | |||
| Won't accept range name | Excel Programming | |||
| control of dialog macro dialog box. on open | Excel Programming | |||
Threaded Mode
