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.
Part I: The Building Blocks for a Successful Customization.
Chapter 1: An Introduction to the Office User Interface.
Chapter 2: Accessing the UI Customization Layer.
Chapter 3: Understanding XML.
Chapter 4: Introducing Visual Basic for Applications (VBA).
Chapter 5: Callbacks: The Key to Adding Functionality to Your Custom UI.
Chapter 6: RibbonX Basic Controls.
Chapter 7: comboBox and dropDown Controls.
Chapter 8: Custom Pictures and Galleries.
Chapter 9: Creating Menus.
Chapter 10: Formatting Elements.
Chapter 11: Using Controls and Attributes to Help Your Users.
Part II: Advanced Concepts in Ribbon Customization.
Chapter 12: Advanced VBA Techniques.
Chapter 13: Overriding Built–in Controls in the Ribbon.
Chapter 14: Customizing the Office Menu and the QAT.
Chapter 15: Working with Contextual Controls.
Chapter 16: Sharing and Deploying Ribbon Customizations.
Chapter 17: Security In Microsoft Office.
Appendix A: Tables of RibbonX Tags.
Appendix B: Tables of Tab and Group idMso Names.
Appendix C: imageMso Reference Guide.
Appendix D: Keytips and Accelerator keys.
Appendix E: RibbonX Naming Conventions.
Appendix F: Where to Find Help.
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.