Hi Edmund,

Try:

Application.DisplayAlerts = False

'Your code

Application.DisplayAlerts = True


---
Regards,
Norman


"Edmund" wrote in message
...
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)