(Solved) – Add custom tab in the ribbon


I am trying to learn something new. I have created a custom tab based on Siddharth Rout’ tutorial.
The XML part is like that

Then in workbook module I put this code so as to activate the tab when the workbook is open

Private myRibbon As IRibbonUI

Sub OnLoad(ribbon As IRibbonUI)
Set myRibbon = ribbon
myRibbon.ActivateTabMso ("MyTab")
End Sub

But when I opened the workbook, I encountered an error Can't run the macro RibbonOnLoad. I am using Office 365 32 Bit and Windows 10 64 Bit.

Leave a Reply

Your email address will not be published. Required fields are marked *