Automatic accept all pop up dialog box

[Edmund]

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 developer’s code will be like impossible.
I’m 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

 

[Norman Jones]

Hi Edmund,

Try:

Application.DisplayAlerts = False

'Your code

Application.DisplayAlerts = True

 

[NickHK]

Edmund,
I think the answer is basically "No".
But I assume you mean there is code like:

RetVal=MsgBox("Really quit ?", vbYesNo)
If RetVal=vbYes Then...

You could do a search and replace of "RetVal=MsgBox..." for "RetVal=vbYes"

NickHK