How to Add Macro Buttons to the Excel Ribbon or Quick Access Toolbar (Part 3 of 4)

Learn how to add custom macro buttons to the Excel Ribbon or Quick Access Toolbar.

This allows you to run macros from your personal macro workbook at any time, on any open workbook.

Read the article and download the Excel file here:

The Excel ribbon can be customized with new Tabs, Groups, and Buttons that will run your macros.

You will also learn how to add macro buttons to the Quick Access Toolbar (QAT). The advantage here is that you can use the Alt+number key keyboard shortcuts to press a QAT button to run your macro. This makes it really fast to run a macro on any open workbook.

Other videos in this series:

How to Create a Personal Macro Workbook in Excel and Why You Need It (Part 1 of 4):

Where Is The Personal Macro Workbook Stored and How to View It (Part 2 of 4):

How to Add a Yes No Pop-up Message Box to a Macro Before it Runs (Part 4 of 4):

Please leave a comment below with any questions, and don't forget to hit the LIKE button if you enjoyed this video. Thank you!!!

[hughrobinson]

Thanks for making this video. I am using an older version of excel (2007). I just added it to the Quick Access Toolbar. This will save me a lot of time once I make all my macros to use on all my spreadsheets. Thanks again.

[vineetjain]

Thank you so much for sharing. Looking forward for more videos with deep learning of VBA.

[SwiftlySwift]

Thankyou so much! I have been searching the internet for what seems like forever to work out how to do this!!

[Risate]

very useful video, my ninja. you made it very easy

[managerlynn]

Thank you so much for the free training. It helps to my job

[sandraellis]

This is fantastic help for speeding things up. Thanks for taking the time to do it so clearly!

[pickymissmn]

Great video! Showed me exactly what I needed to know quickly! Thank you!

[apiitg]

Thank you so much. This is a great series. You are a great teacher and an excel genius.

[petratimar]

thanks :) I like this elegant solution. :)

[rimantasdanilevicius]

good intro and useful info, thank you

[jfyfe]

Very nice explanation and well presented!

[pramodesys]

Indeed a very useful tip.... thanks a lot.

🙏🙏

[johnpaden]

Excellent content. Well-organized presentation.

[ganeshs]

thank you helped a lot. Knew this was there somewhere in Ms Office

[HforHelm]

It helped me in my work thank you sir.

[erich]

Great series.. these videos were very helpful.... much appreciated.

[flowcharttocodeconverter]

Good info 👍🏻
Let know if we can add our own pictures in addition to the existing ones which we see if select INSERT -> PICTURES Option. Thanks

[Ghostmanbattlecraft]

pro tip : if hes going too slow in the video for your liking then just bump up the playback speed to 1.75 saves a bunch of time.

[stefanogattoCH]

Thank you for the clear explanations! Is there a way to add the new buttons in the ribbon only when the user opens the workbook (or addin) containing the functionality launched by the tools? I also need to know how to remove those new buttons in the ribbon, as soon as the user closes the workbook (or addin) carrying that same functionality. Can we do this with VBA?

[sTdwares]

Awesome! Just tell me this one thing.
If I export customization in my computer and then later import it on your computer, do I have to share my Personal Workbook with you as well, or will it take care of that automatically? How would your computer find the Macros that I have stored in my personal workbook, otherwise?

Thanks for explaining this...