Quick Access Toolbar shortcut icon to run macro in MS Office apps


When creating a macro in an MS Office app (ie Outlook 2010), how do you then:

        1) create a shortcut icon and

        2) place the new icon on your Quick Access Toolbar (QAT)?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
Quick Access Toolbar died some time back. What operating system are you using?
Joe Winograd, Fellow&MVEDeveloperCommented:
Hi Steve,

I think that John is not interpreting the QAT correctly, as it is alive and well in Office 2010 — and even in Office 2013.

I'll send you detailed instructions soon, but I'm creating them from scratch and it will take me about a half-hour to test the method and capture the screenshots along the way. Regards, Joe
JohnBusiness Consultant (Owner)Commented:
There is a QAT in Windows (now dead) and a different Quick Access icon in Office that is alive and I use it. Which one are you talking about.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Joe Winograd, Fellow&MVEDeveloperCommented:
Hi Steve,

Here are the steps in Outlook 2010 (and they're the same in Outlook 2013):

Click the QAT drop-down and select More Commands...:

Outlook 2010 Customize QAT
Click the Choose commands from drop-down and select Macros:

QAT Macros
Click the Macro you want (in my test it is HelloWorld) and then the Add button:

Add to QAT
Click the Modify button and you'll get a choice of icons (in my test I picked the yellow smiley):

Click OK and that will place the icon on your QAT:

Icon on QAT
Click the icon and it will run your Macro:

Run Outlook 2010 Macro via QAT icon
Regards, Joe

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
WeThotUWasAToadAuthor Commented:
Thanks Joe,

This is a classic Joe Winograd reply — simple and clear explanation with lots of pics.

After starting to follow the steps you provided, I realized I first need to create the macro — which I usually do in Excel & Word by using the Macro Recorder. However, Outlook apparently does not have one. Therefore, I just created an associated thread to get the code.

Once I have that, I'm sure I will be able to sail right through your great instructions.

Take care and have a great weekend!
Joe Winograd, Fellow&MVEDeveloperCommented:
Thanks for the kind words — I really appreciate hearing them! You are correct — Outlook does not have a Macro Recorder — you have to write VBA code. I'll take a look at your new question to see if I can help. You have a great weekend, too! Regards, Joe
Martin LissOlder than dirtCommented:
I've requested that this question be closed as follows:

Accepted answer: 500 points for Joe Winograd's comment #a40888068

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
WeThotUWasAToadAuthor Commented:
Thanks again for the great explanation Joe (including the screenshots). I really appreciate it!

My apologies for the delay in responding.
Joe Winograd, Fellow&MVEDeveloperCommented:
You're welcome, Steve. And thanks again to you for the kind words. No problems on the delay in responding. Hope all is well in your world. Regards, Joe
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.