How to add a custom Ribbon tab using VBA?
AFAIK you cannot use VBA Excel to create custom tab in the Excel ribbon. You can however hide/make visible a ribbon component using VBA. Additionally, the link that you mentioned above is for MS Project and not MS Excel. I create tabs for my Excel Applications/Add-Ins using this free utility called Custom UI Editor. Edit: … Read more