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.
