message box appears and appears

  • Thread starter Thread starter Wanna Learn
  • Start date Start date
W

Wanna Learn

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

message box in worksheet 1
Checkbox Next to Mail Message - How Do I Make It Visible? How Do I Make a Check Appear? 1
How to get pi to appear in a message box when coded using VBA 0
Create a yes no message on a command button on click 0
Export as pdf form to ipad 2
Select avaya cms server from shell option VBA 0
Enter Parameter Value in Access Form 0
Help with Ribbons! AAARGH! 10

Back
Top