View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 19
Default Tab through & hit enter through a message box with a macro

Hi Guys,

I have a macro that executes fine except for four message boxes that
pop up. One is a "Microsoft Visual Basic" box that says "file not
found". I basically know what the issue is, but for now I want to just
to be able to hit "enter" and move on. The next box reads "Microsoft
Office Outlook" stating "Do I want to email the file?" I want to tab
over twice and select the option of "yes". The last message box is
asking, do I want to save the file I just worked with. The answer is
"no" so I want to be able to tab over twice and depress "enter".
Finally the last box comes up with the same message for another file
the macro opened. I want to answer "no" for that option as well.

Thanks guys for your help.

Sam