Recently got Office 2016 and am trying to set up a custom tab on the ribbon.
I've Coded necessary Subs and saved the book as .xlam in the standard MS Addins folder:
Sub Ribboncont1(ByVal Control as IRibbonControl)
...blah blah
End Sub
Sub Ribboncont2(ByVal Control as IRibbonControl)
...blah blah
End Sub
I opened a new book and ticked my addin in Developer/Addins/Excel Addins but when I select "Customise the Ribbon" only the first sub Ribboncont1 appears in the macros list. Tried putting Ribboncont1 and 2 in separate addin books but makes no difference.
Any ideas? Cheers.
I've Coded necessary Subs and saved the book as .xlam in the standard MS Addins folder:
Sub Ribboncont1(ByVal Control as IRibbonControl)
...blah blah
End Sub
Sub Ribboncont2(ByVal Control as IRibbonControl)
...blah blah
End Sub
I opened a new book and ticked my addin in Developer/Addins/Excel Addins but when I select "Customise the Ribbon" only the first sub Ribboncont1 appears in the macros list. Tried putting Ribboncont1 and 2 in separate addin books but makes no difference.
Any ideas? Cheers.
Comment