In Excel 2010 onwards you can create your own Ribbon Tabs as well as add your own Macros to them! Let’s learn how really easy this is to do.
This is really useful if you have a set of commands you use on a regular basis and want 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.
Firstly- Create our very 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?
- 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).
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.
Advanced Excel & Power Pivot Training Classes
Become a Data Analysis & Dashboarding Monster!