• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

Excel addins

xoggoth

More fingers than teeth
Joined
Jul 8, 2005
Messages
17,131
Likes received
4,950
Thanks received
1,184
Location
xoggoth towers
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.
 
Cheers lm, I believe the old methods of messing about with xml in the package still work, still the only solution in Word, but Excel 2016 is supposed to make it all much easier. In theory!
 
Was a cockup on my part.

One thing I don't like about Excel 2016 is the way that saving a file is a two step process with that new File page. Now have nice simple Save, Save As and New buttons on the Home tab. If anyone wants a simple guide, there are none on the net, reply here.
 
Cheers WTFH, got butts on there too but you do need to code. If you use standard Save it's the same as clicking File, it takes you to the File page, and then you have to click save again. Then, if you have any external links on the page, you have to save again on exit, cos the sheet is changed when you return to it.
 
Last edited: 18:21

Advertisers

Back
Top