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
--
Edmund
(Using Excel XP)

[Norman Jones]

Hi Edmund,

Try:

Application.DisplayAlerts = False

'Your code

Application.DisplayAlerts = True


---
Regards,
Norman


"Edmund" <Edmund@discussions.microsoft.com> wrote in message
news:B4E45B04-2C9F-4C90-8C26-FD4D7AFC14A5@microsoft.com...
> 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
> --
> Edmund
> (Using Excel XP)

[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

"Edmund" <Edmund@discussions.microsoft.com> wrote in message
news:B4E45B04-2C9F-4C90-8C26-FD4D7AFC14A5@microsoft.com...
> 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
> --
> Edmund
> (Using Excel XP)