IHello Excellers, welcome back to today’s #excel #macromonday blog post in this 2019 series. Today I will show you how to add your own Excel macros you have written to the ribbon.
With Excel 2010 onwards you can create your own Ribbon Tabs. You can also add your own Macros to them! Let’s learn how really easy this is to do.
It is really useful to have a set of commands you use on a regular basis. I like to keep them on a totally separate tab. In my example in this tutorial let’s create a new tab called My Tab and add two macros that we have created.
Create Your Own Ribbon Tab
- Right click on the Ribbon Area and hit ‘Customize Ribbon’ option
- Customize Ribbon
- Under Main Tabs, select the tab that you want your new tab to come before
- A New Tab (Custom) is added and a single group called New Group (Custom)
- To Rename the custom Tab or Group (I have renamed mine MACROS), select it and hit Rename
- Hit Ok and your new Tab and or Group will be created
Ok, so that is our new Excel Tab sorted- how about adding some of our own macros to it?
Add Your Macros To Ribbon
- The first step is really simple- hit File- Menu
- Then Customize Ribbon in the Excel Options Dialog box
- Click Macro in the Choose Commands From drop-down list box on the left- Excel will list the names of all of the macros that have been created in the current workbook in the Choose Commands From list box
- Click the name of the custom tab to which you want to add the macro- in this case, it is MACROS
- In the Choose Commands From list box on the left, click on the name of the macro you want to add to the custom tab
- Click Add to the select the macro ( in the case MY MACRO then click Ok to close the Excel Options dialog box).
Finally, after you have added your macro to your tab, the name of the macro appears on a button and given a generic icon (which just happens to be a programming diagram chart).
Just click on the command button of the macro to run it as you would a normal macro. How easy is that?.
If you want more tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips.
Likewise, if you want to see all of the blog posts in the Macro Mondays Series Click The Link Below
So, Don’t forget to SUBSCRIBE to the How To Excel At Excel Newsletter for more tips the first Wednesday of the month.