Cover image for RibbonX : Customizing the Office 2007 Ribbon.
RibbonX : Customizing the Office 2007 Ribbon.
Title:
RibbonX : Customizing the Office 2007 Ribbon.
Author:
Martin, Robert.
ISBN:
9780470288528
Personal Author:
Edition:
1st ed.
Physical Description:
1 online resource (688 pages)
Contents:
RibbonX -- About the Authors -- Credits -- Contents -- Acknowledgments -- Introduction -- Overview of the Book and Technology -- How This Book Is Organized -- Why Read This Book -- Tools You Will Need -- What's on the Website -- Congratulations -- Part I: The Building Blocks for a Successful Customization -- Chapter 1: An Introduction to the Office User Interface -- What Is the Ribbon and Why Does It Exist? -- What Happened to the Toolbars from My Pre-2007 Files? -- A Customization Example for Pre-2007 UIs -- Ribbon Components -- Tips for Navigating the Ribbon and Quick Access Toolbar (QAT) -- Preparing for Ribbon Customization -- Conclusion -- Chapter 2: Accessing the UI Customization Layer -- Accessing the Excel and Word Ribbon Customization Layers -- Microsoft Access Customizations -- Conclusion -- Chapter 3: Understanding XML -- What Is XML and Why Do You Need It? -- Essential Background -- The Core XML Framework -- The customUI Element -- The ribbon Element -- The tabs Element -- The tab Element -- The group Element -- Conclusion -- Chapter 4: Introducing Visual Basic for Applications (VBA) -- Getting Started with Visual Basic for Applications (VBA) -- Recording Macros for Excel and Word -- Subprocedures versus Functions -- VBA Coding Techniques -- Writing Your Own Code -- Debugging Your Code -- Error Handling -- Working with Arrays -- Conclusion -- Chapter 5: Callbacks: The Key to Adding Functionality to Your Custom UI -- Callbacks: What They Are and Why You Need Them -- Setting Up the File for Dynamic Callbacks -- Generating Your First Callback -- Calling Procedures Located in Different Workbooks -- Organizing Your Callbacks -- Invalidating UI Components -- Conclusion -- Chapter 6: RibbonX Basic Controls -- The button Element -- The checkBox Element -- The editBox Element -- The toggleButton Element -- Conclusion.

Chapter 7: comboBox and dropDown Controls -- The item Element -- The comboBox Element -- The dropDown Element -- Conclusion -- Chapter 8: Custom Pictures and Galleries -- Custom Pictures -- Adding Custom Pictures to Excel or Word Projects -- Adding Custom Pictures to Access Projects -- Using GDI+ to Load PNG Files -- Using the Gallery Control -- Conclusion -- Chapter 9: Creating Menus -- The menu Element -- The splitButton Element -- The dynamicMenu Element -- Conclusion -- Chapter 10: Formatting Elements -- The box Element -- The buttonGroup element -- The labelControl Element -- The separator Element -- The menuSeparator Element -- Conclusion -- Chapter 11: Using Controls and Attributes to Help Your Users -- The dialogBoxLauncher Element -- The keytip Attribute -- screentip and supertip Attributes -- Overwriting Built-in Control Attributes -- Conclusion -- Part II: Advanced Concepts in Ribbon Customization -- Chapter 12: Advanced VBA Techniques -- Working with Collections -- Class Modules -- Using VBA Custom Properties -- Saving and Retrieving Values from the Registry -- Conclusion -- Chapter 13: Overriding Built-in Controls in the Ribbon -- Starting the UI from Scratch -- Activating a Tab at Startup -- Disabling and Repurposing Commands -- Conclusion -- Chapter 14: Customizing the Office Menu and the QAT -- Adding Items to the Office Menu -- Adding Items to the QAT -- Conclusion -- Chapter 15: Working with Contextual Controls -- Making Your Items Contextual -- Working Through Nonvisibility Methods -- Working with Contextual Tabs and tabSets -- Working with Contextual Pop-up Menus -- Multilingual UI -- Conclusion -- Chapter 16: Sharing and Deploying Ribbon Customizations -- Excel Deployment Techniques -- Word Deployment Techniques -- Sharing Ribbon Items Across Files (Word and Excel).

Deploying Word and Excel Solutions Where Multiple Versions of Office are in Use -- Access Deployment Techniques -- Conclusion -- Chapter 17: Security In Microsoft Office -- Security Prior to Office 2007 -- Macro-Enabled and Macro-Free File Formats -- The Trust Center -- Digital Certificates -- Conclusion -- Appendix A: Tables of RibbonX Tags -- How to Use This Appendix -- Ribbon Container Elements -- Ribbon Control Elements -- Appendix B: Tables of Tab and Group idMso Names -- Common Tab idMso Identifiers -- Contextual Tab idMso Identifiers -- Group idMso Identifiers -- Appendix C: imageMso Reference Guide -- How to Get Your Own imageMso References -- Your Own Reference Tool -- Appendix D: Keytips and Accelerator keys -- Keytips and Accelerator Keys for Excel -- Appendix E: RibbonX Naming Conventions -- How Our Naming System Works -- Naming Samples -- Appendix F: Where to Find Help -- Websites with RibbonX Information -- Websites Maintained by the Authoring and Tech Edit Team -- Newsgroups -- Web Forums -- Index.
Abstract:
As the most radical change to the Office interface in its history, the Ribbon replaces the traditional menu bar and toolbars and requires a new set of skills for customizing Instructions and examples demonstrate how to customize the Ribbon using VBA, XML, Access, Excel, and Word Covers the relevant aspects of security, such as trust centers and digital certificates Packed with real-world code examples that readers can immediately apply Features helpful references.
Local Note:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2017. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Electronic Access:
Click to View
Holds: Copies: