• RRP: £31.99
  • You Save: £10.24 (32%)
FREE Delivery in the UK.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
RibbonX: Customizing the ... has been added to your Basket
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

RibbonX: Customizing the Office 2007 Ribbon Paperback – 4 Jan 2008

4.0 out of 5 stars 4 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
"Please retry"
£17.36 £17.82
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more

Top Deals in Books
See the latest top deals in Books. Shop now
£21.75 FREE Delivery in the UK. Only 1 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.
click to open popover

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.

Top Deals in Books
See the latest top deals in Books. Shop now

Product details

  • Paperback: 688 pages
  • Publisher: John Wiley & Sons; 1 edition (4 Jan. 2008)
  • Language: English
  • ISBN-10: 0470191112
  • ISBN-13: 978-0470191118
  • Product Dimensions: 18.5 x 3.8 x 23.4 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: 1,048,342 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From the Back Cover

Microsoft MVPs teach you new skills for customizing the Ribbon

If you like to build custom applications or customize the Office user interface, this book is for you. Written by a team of Microsoft MVPs, it shows you step by step how easy it is to modify the Microsoft Office® 2007 Ribbon, how the Ribbon works, and how you can customize it to add functionality. You′ll learn to leverage the RibbonX API to hide, create, add, and group controls.

Along with techniques for using XML, VBA, and Access macros, you′ll find clear instructions, practical examples, and real–world code you can use. This is the perfect guide for beginners, developers, and power users alike.

  • Explore the Ribbon user interface and Quick Access Toolbar

  • Access the CustomUI Editor and start modifying

  • Learn the essentials of XML and why you need it

  • Write and debug your own code with Visual Basic® for Applications (VBA)

  • Master RibbonX basic controls and create custom, static, and dynamic menus

  • Deploy your Ribbon customizations across files

  • Gain a working knowledge of key aspects of Office security such as digital certificates and privacy settings

Inside you′ll also find a handy table of RibbonX tags, a tool to quickly reveal the imageMso references and generate its XML, and much more.

About the Author

Robert Martin is an Excel MVP and Microsoft Certified Professional. With a background in finance, he has worked as an IT director for an investment bank in the UK, and worked on charitable projects in Africa before turning to authoring on MS Office development.

Ken Puls is an Excel MVP and a Certified Management Accountant in Canada. He works as the Controller of a resort, teaches Excel courses, and has authored all of the articles at the www.excelguru.ca website.

Teresa Hennig is an Access MVP and president of the Pacific Northwest Access Developer Group and the Seattle Access Group. She is the lead author of the Access VBA Programmer′s Reference series and is a lead on three national committees for INETA. Her company, Data Dynamics Northwest, provides data management solutions and consulting services.

Customer Reviews

4.0 out of 5 stars
Share your thoughts with other customers

Top Customer Reviews

Format: Kindle Edition
I had bought this many years ago, when Excel 2007 came out, but never had any occasion to really read it or use it.
Now that I'm working for an employer who really wants ribbons on all the Excel VBA front-ends, I started to work through this book. I've found everything in here that I've used is still applicable to Office 2010 and presumably Office 2013.

It is AMAZINGLY comprehensive for something that is really badly explained by Microsoft and on the web. I highly advise you to download the companion content so that you can see the ribbon at work in the sample office documents. Programming the ribbon is a really fiddly enterprise where the slightest typo means that things don't work and you are not told why.

The authors have done a really good job taking what is essentially a beta-technology and giving us scraps of programmability so that we too can have some ribbons.
Many people complain about the ribbon and would love to return to menus, I used to understand that, but now I love Ribbons. I think they are really really well designed.
Their programmability is another matter and this is what this book is about. Programming the Office 2007 Ribbons with examples for Word/Excel/Access...

This is not the kind of book you read from cover to cover. If you need to create a Ribbon menu you go to that section, if you want to add only checkboxes, you look them up in the index.
It lists exhaustively what programmatic function signatures all the callbacks have to be in order for you to programmatically interact with your ribbon controls.

Finally I leave you with a tip:
Don't think of the Ribbon controls as nameable entities that you can query at run time such as "what is the content of my date dropdown on my custom Tab?
Read more ›
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
It came in handy for sure and it's full of details covering the main Office appliations of Excel, Word and Access.
When it came to "Contextual Tabs" in Access I couldn't find something important and had to find it online.
In the Backstage Options you need to have it set for "Overlapping Windows" not "Tabbed Windows" to get contextual tabs to work properly.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Having used VB to create extensive drop-down menus in earlier versions of Excel, I wanted to be able to recreate those menus in Excel 2007/2010. This book has enabled me to achieve what I set out to do.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Switching from Office 2003 to RibbonX has caused much lamenting on the woeful documentation available to help.

This book fills the gap. Sometimes it seems to be bulking itself up a bit unnecessarily - but I'll forgive it that as its helped me get on with my business and has thus paid for itself a few times over already.

In short - tearing your hair out with the change to developing for the Ribbon interface with VBA ? This book will help.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 4.7 out of 5 stars 18 reviews
5.0 out of 5 stars Fabulous 5 Feb. 2013
By Mark Trevithick - Published on Amazon.com
Format: Paperback Verified Purchase
It's hard to imagine a book on coding being a joy to read, but the authors of RibbonX did a superb job of presenting the material in an easy to read style and provide far more information than I ever imagined could be in a book on programming the Office Ribbon (Microsoft's Fluent interface).

I intended to use the book as a reference, but find myself reading through it chapter by chapter. Even the chapter on vba which I've been coding for years. I figure that as much expertise as the authors possess, I just might learn something new.

The only things that could make it better would be a CD/DVD of the files (available on Wiley) and the text of the book in pdf, and even more beneficial would be an Office 2010 edition.
12 of 13 people found the following review helpful
3.0 out of 5 stars RibbonX Book Gets a "C" 25 May 2008
By Robert Homes - Published on Amazon.com
Format: Paperback Verified Purchase
This book covers the new "Ribbon" interface used in Microsoft Office 2007. The Ribbon replaces the old menus and toolbars in Office programs, and unlike the menus and toolbars cannot be modified or added to easily. The new Office programs have only one toolbar, called the Quick Access toolbar, to which you can add toolbar buttons to run commands and macros; and there are no more menus.

The book teaches you the difficult process needed in order to modify the Ribbon in each Office program. It is not an easy process, as it involves writing XML code in addition to macro programming code. And opening the necessary XML files in order to modify them isn't easy either.

The book does a fairly good job of presenting the process, and documenting the various XML "tags" needed. However, it is not well written, and its explanations of the programming concepts are a bit muddled, especially for novices like me. The constant statements of "we'll explain this later" become aggravating after awhile; its like the authors themselves are feeling their way along with their readers. I guess by the end of the book, they have figured out what they were trying to teach; that should make the next edition a little better!

One thing you should know if you want to modify the Ribbon in the Office programs is that there are programs out there that have been and are being written to automate the process so that you don't really need to know the details in the depth this book attempts to teach. (But having this book could be a help in using and understanding those programs.) There are two programs available now, one of which is called RibbonCustomizer (and is very well designed).

Also, if you are a programmer using Visual Studio 2008, you can obtain from Microsoft a free addin called VSTO (Visual Studio Tools for Office) that contains features that allow you to write your own programs to modify the Ribbon. I'm not sure about this (I'm a novice programmer myself), but I think the free VSTO addin for VS 2008 eliminates the need to purchase the VSTO program separately. You had to pay a hefty price for the VSTO program needed as an addin for VS 2005, but it seems that now it can be added for free to VS 2008.
5.0 out of 5 stars All you need is there 21 Sept. 2013
By Milan Hudec - Published on Amazon.com
Format: Paperback Verified Purchase
There's no need comments.
All you need, as VBA programer, who work with office apps, is in the book.
Just read, write code, and have a fun :)
5.0 out of 5 stars Need to work with the Office ribbon? Buy this book. 30 Aug. 2013
By Twark Main - Published on Amazon.com
Format: Kindle Edition Verified Purchase
It's really quite that simple. If you need to work with the Office Ribbon and don't have this book, you're wasting time and money.
5.0 out of 5 stars Five Stars 30 Nov. 2014
By VICTOR HUGO RUIZ - Published on Amazon.com
Format: Kindle Edition Verified Purchase
Easy to read and comprehend. I recommend it
Were these reviews helpful? Let us know