I would like to modify the Excel Ribbon to include icons that will run Sub procedures in an Excel Add-In that I'm developing. I've been relying on John Walkenbach's "Excel 2013 Power Programming with VBA" as a resource, but this particular topic is not covered extensively. If anyone could point me to some resources or well documented examples, I would greatly appreciate it.
Thank you.
Look for the book
RibbonX Customizing the Office 2007 Ribbon
by Robert Martin, Ken Puls, and Teresa Hennig
The Ribbon interface really hasn't changed since then, and this will apply to 2010 and (I think), 2013 and 2016.
There is also a much less expensive Kindle book (but I have not used it, so cannot say how thorough it is):
OfficeFest 2007: Customizing the Ribbon in Microsoft Office 2007/2010
Last edited by Bernie Deitrick; 04-20-2016 at 03:14 PM.
Bernie Deitrick
Excel MVP 2000-2010
Thank you, Bernie. Much appreciated.
I purchased the book ($50) and meticulously followed the very first example in Chapter 2 (adding a Tab to an Excel ribbon), and alas it did not work. I next tried to use the Custom UI Editor and it also failed. I am using Excel 2016. I'm not sure where to turn to next. Is there a more recent book that covers this subject for this newer version of Office?
If you open a workbook with a Ribbon customization, does it appear in 2016? What happens when you open the file below?
And, most importantly, does 'brassrat' mean you are an MIT graduate?
Yes the extra Ribbon group is there on the Data tab, and yes I'm an MIT grad.
I guessed - I'm an '81 BS ChE grad, though I never wear my brass rat - there are painful edges on my class's version.
Can you build on that code to figure out what you need to do? My initial few attempts when the Ribbon first appeared were pretty dismal, and IIRC, I needed to download a working sample before I figured it out...
Good luck!
Just to let you know I was able to get this to work after I abandoned the UI Editor in place of Notepad for the purpose of crafting the customUI.xml file. Thanks again for your assistance, Bernie. ChE 93 btw.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks