- 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
RibbonX: Customizing the Office 2007 Ribbon Paperback – 4 Jan 2008
|New from||Used from|
- Choose from over 13,000 locations across the UK
- Prime members get unlimited deliveries at no additional cost
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
Customers Who Bought This Item Also Bought
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.
To get the free app, enter your mobile phone number.
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.
Top Customer Reviews
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 ›
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.
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.
Most Helpful Customer Reviews on Amazon.com (beta)
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.
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.
All you need, as VBA programer, who work with office apps, is in the book.
Just read, write code, and have a fun :)
Look for similar items by category
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Microsoft Windows > Applications > Access > ECDL
- Books > Computing & Internet > Microsoft Windows > Applications > Office
- Books > Computing & Internet > Programming > Languages & Tools
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Office Suites