Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
message box appears and appears
Hello
I created a form for the sales force to use. When cell D13 is selected a message box appears with some information I added a command button and added the Sub Mail_Selection_Range_Outlook_Body() from Ron De Bruins site. when ever I submit the form the message box appears. If a select ok then the email is created then everything is fine. I do not want the message box to appear again when I am sending the email. How do I fix that? thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
message box appears and appears
At the beginning of your mail sub, add this line:
Application.EnableEvents = False and at the end of the sub: Application.EnableEvents = True I'm assuming you have the message box displayed based on an event macro, so this will prevent the event from being triggered. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Wanna Learn" wrote: Hello I created a form for the sales force to use. When cell D13 is selected a message box appears with some information I added a command button and added the Sub Mail_Selection_Range_Outlook_Body() from Ron De Bruins site. when ever I submit the form the message box appears. If a select ok then the email is created then everything is fine. I do not want the message box to appear again when I am sending the email. How do I fix that? thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error message #N/A appears in linked cells | Links and Linking in Excel | |||
How do I keep the ding sound from playing when a message appears? | Excel Discussion (Misc queries) | |||
How do I control where the input message appears? | Excel Discussion (Misc queries) | |||
Urgent- Help ! (Message 'Calculate' Appears) | Excel Discussion (Misc queries) | |||
How do i change the location where the input message appears | Excel Discussion (Misc queries) |