WeThotUWasAToad
asked on
Quick Access Toolbar shortcut icon to run macro in MS Office apps
Hello,
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)?
Thanks
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)?
Thanks
John
Quick Access Toolbar died some time back. What operating system are you using?
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
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
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!
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!
Steve,
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
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
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.
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.
ASKER
Thanks again for the great explanation Joe (including the screenshots). I really appreciate it!
My apologies for the delay in responding.
My apologies for the delay in responding.
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