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.