View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Edmund Edmund is offline
external usenet poster
 
Posts: 62
Default 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)