RibbonX: Customizing the Office 2007 Ribbon and over 2 million other books are available for Amazon Kindle . Learn more
  • RRP: £26.99
  • You Save: £5.65 (21%)
FREE Delivery in the UK.
Temporarily out of stock.
Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we dispatch the item.
Dispatched from and sold by Amazon.
Gift-wrap available.
RibbonX: Customizing the ... has been added to your Basket
Trade in your item
Get a £8.34
Gift Card.
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

3 customer reviews

See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
"Please retry"
£14.35 £14.49
£21.34 FREE Delivery in the UK. Temporarily out of stock. Order now and we'll deliver when available. We'll e-mail you with an estimated delivery date as soon as we have more information. Your account will only be charged when we dispatch the item. Dispatched from and sold by Amazon. Gift-wrap available.

Special Offers and Product Promotions

  • Win a £5,000 Amazon.co.uk Gift Card for your child's school by voting for their favourite book. Learn more.
  • Prepare for the summer with our pick of the best selection for children (ages 0 - 12) across Amazon.co.uk.

Win a £5,000 Amazon.co.uk Gift Card and 30 Kindle E-readers for your child or pupil's school.
Vote for your child or pupil(s) favourite book(s) here to be in with a chance to win.

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.7 x 3.5 x 23.5 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (3 customer reviews)
  • Amazon Bestsellers Rank: 513,435 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

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.

Inside This Book

(Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

4.0 out of 5 stars
Share your thoughts with other customers

Most Helpful 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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
By Timothy M Read on 14 April 2011
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. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
By Lilly8 on 25 May 2013
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. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 16 reviews
12 of 13 people found the following review helpful
RibbonX Book Gets a "C" 25 May 2008
By Amazon Customer - 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.
3 of 3 people found the following review helpful
What are you waiting for? 21 Jan. 2008
By Tony Jollans - Published on Amazon.com
Format: Paperback
Everything about the Ribbon is new; all serious developers will need, and many others will want, to know how to customize it, and this book tells you how to do it. The authors have done a splendid job of explaining it all without assuming any prior knowledge, guiding the reader through the jungle of VBA and XML in three different applications. It is a huge subject and different people will want different things from it; the book is packed (but not cluttered) with clear cross-references so that you don't have to read everything to get up and running with the particular thing you want to do. No matter what your ability or experience you will learn from this book, I already have. As computer books go, it's better than most, it's cheap, and worth far more: buy it!
5 of 6 people found the following review helpful
Embrace the Ribbon 31 Jan. 2008
By Robert Larson - Published on Amazon.com
Format: Paperback
If you are ready to work with Microsoft Office 2007, and make it your own, the book "RibbonX, Customizing the Office 2007 Ribbon" is the book for you. I started out with no XML knowledge, and no experience in customizing the new Office 2007 Ribbon, and within a very short time I had created my very first customized Ribbon. The book goes into some XML and VBA basics and is comfortable reading for a true beginner as well as those who may have more experience. In this past year, which I have been working with Office 2007, I have been intimidated by the thought of venturing into Ribbon territory. After reading this book, I no longer fear the Ribbon. In fact, I embrace the opportunities that are awaiting my use of it.

So, I highly recommend this book for anyone who wants to be able to customize their own Office 2007 experience, or the experience of the users of their creation. You won't want to be without it.

Bob Larson
Access World Forums Super Moderator
Utter Access VIP
1 of 1 people found the following review helpful
RibbonX Wow Factor 23 Feb. 2008
By Doug Y. - Published on Amazon.com
Format: Paperback
While the new user interface of Office 2007, the ribbon, added some confusion in the beginning, the power behind customizing it definitely tips the scale toward "wow". This book helps developers harness the power behind the ribbon, and walks you through the steps to create your own custom ribbons.

I liked discovering the ribbon customization for the three applications discussed in the book (although I focused mainly on Access); and, the tools mentioned in the book, XML Notepad and the Custom UI Editor, made the process easier. While the book is also geared to users with little or no experience in ribbon development, if you are new to XML and VBA, it may not be as smooth a read as it would be if you already have some basic knowledge under you belt. However, if you are determined to learn the new techniques (and looking up this book is an indication that you are), you will end up gaining a solid foot in the custom ribbon development arena with the help of this book.
1 of 1 people found the following review helpful
RibbonX Reference Guide 18 Mar. 2008
By Craig A. Reitan - Published on Amazon.com
Format: Paperback
This book is well written for users who have no prior knowledge of ribbon or menu programming in Office. The background information on how the new ribbon was developed is good for providing some insight on how it was developed and how to take advantage of it in your development work.

Previously I have worked with VBA in Access and had no background in programming for the menu or ribbon. The VBA section of the book was most helpful in that the authors examples can relate your prior experiences.

The coverage of the topic of XML is very good for getting through the parts you need to use in prograsmming the ribbon without overloading the reader.

After having worked with the examples in RibbonX, I still like to use the book as a desktop reference. The use of well organized tables listing the functions and their optional and required parameters is very handy.
Were these reviews helpful? Let us know