how to add custom ribbon to excel 2010 in vba

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.Then Customize Ribbon in the Excel Options Dialog box.The first step is really simple- hit File- Menu.Ok, so that is our new Excel Tab sorted- how about adding some of our own macros to it? Add Your Macros To Ribbon Hit Ok and your new Tab and or Group will be created.To Rename the custom Tab or Group (I have renamed mine MACROS), select it and hit Rename.A New Tab (Custom) is added and a single group called New Group (Custom).Under Main Tabs, select the tab that you want your new tab to come before.Right click on the Ribbon Area and hit ‘Customize Ribbon’ option.In my example in this tutorial let’s create a new tab called My Tab and add two macros that we have created. I like to keep them on a totally separate tab. It is really useful to have a set of commands you use on a regular basis.

You can also add your own Macros to them! Let’s learn how really easy this is to do. With Excel 2010 onwards you can create your own Ribbon Tabs. Today I will show you how to add your own Excel macros you have written to the ribbon. IHello Excellers, welcome back to today’s #excel #macromonday blog post in this 2019 series.

How to add custom ribbon to excel 2010 in vba