Solved

Outlook 2010 Custom Form

Posted on 2014-04-09
1
820 Views
Last Modified: 2014-05-05
Hi,

I have created a Outlook 2010 custom form that has a "Send button" on the main form.

Is there anyway I can "Hide" the send button on the toolbar / Ribbon while in this custom form (only) as some users are hitting this button which byepasses all the VBA Code.

Thank you in advance
0
Comment
Question by:Mongo Peck
1 Comment
 
LVL 76

Accepted Solution

by:
David Lee earned 500 total points
ID: 39991151
There is no way I know of to hide the "Send" button on the ribbon when your custom form is open.  That's probably not really necessary though as there are other ways to handle this.  

1.  Move the code that runs when the user clicks your Send button to the Item_Send function in your form.  This function is triggered each time the form is sent.  If yout ake this approach, then the users can use the regular Send button while retaining all the functionality you had with your own Send button.

Function Item_Send()
    'Your code goes here
End Function

Open in new window


2.  Add an ItemSend event handler macro to each user's computer.  Move the code from your form to this procedure.  While this approach will solve the problem, it isn't especially practical particularly if you have more than a few people who will be using your form.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Create high volume marketing opportunities using email signatures with these top 10 DOs and DON'Ts of email signature marketing.
Follow this checklist to learn more about the 15 things you should never include in an email signature from personal quotes, animated gifs and out-of-date marketing content.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now