LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to select cells in column enter data then press enter NP New Users to Excel 1 February 20th 08 04:21 PM
received message: Can't enter break mode at this time William Weder Excel Programming 0 March 1st 06 01:58 AM
Macro to enter blank row MissyLovesExcel Excel Programming 2 December 6th 05 04:55 PM
How do I input a warning message to remind the user to enter into. sugarbrit17 Excel Discussion (Misc queries) 3 January 25th 05 08:31 PM
How to use macro to enter password? Ankan[_4_] Excel Programming 1 December 23rd 03 12:12 AM


All times are GMT +1. The time now is 09:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"