#How to add the developer tab in excel mac code
The amended code now looks like this: ĭelete all the code which was generated in CUIE and then paste the above code in lieu of that. Let's keep happy face as the image of the first one and let's keep the "Sun" for the second. With that, let's create 2 buttons and call them "JG Button 1" and "JG Button 2". OnAction="Callback": "Callback" is the name of the procedure which runs when you click on the button. "HappyFace" is what you will see at the moment. ImageMso: This is the image that will display on the button. For the time being let's call it "Jerome". Label="Custom Tab": Replace "Custom Tab" with the name which you want to give your tab. 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.