how to add custom ribbon to excel 2010 in vba

Now you are all set to edit it as per your requirements. You will notice that the basic code is automatically generated.

Next Click on menu Insert | Sample XML | Custom Tab. Right click as shown in the image below and click on 'Office 2007 Custom UI Part'. I am using a brand new worksheet as an example. Please ensure that the Excel File is closed before you open it via CUIE. I create tabs for my Excel Applications/Add-Ins using this free utility called Custom UI Editor.Įdit: To accommodate new request by OP TutorialĪfter you have installed the Custom UI Editor (CUIE), open it and then click on File | Open and select the relevant Excel File.

Additionally, the link that you mentioned above is for MS Project and not MS Excel. You can however hide/make visible a ribbon component using VBA. I tried this example from here but get an 'object required' error on the last instruction : Public Sub AddHighlightRibbon()ĪFAIK you cannot use VBA Excel to create custom tab in the Excel ribbon. What is a quick and simple way to do that ? I'd like the new tab to get loaded when my VBA gets loaded into Excel. I chanced on some resources addressing it via Google but all look dodgy and outrageously complicated.

I am looking for a way to add a custom tab in the Excel ribbon which would carry a few buttons.

How to add custom ribbon to excel 2010 in vba