RibbonX [[electronic resource] ] : customizing the Office 2007 Ribbon / / Robert Martin, Ken Puls, Teresa Hennig

• Record Nr.: UNINA9910810240203321
• Autore: Martin Robert <1972->
• Pubbl/distr/stampa: Indianapolis, IN, : Wiley Pub., c2008
• ISBN: 1-281-20430-7; 9786611204303; 0-470-28852-3
• Edizione: [1st edition]
• Descrizione fisica: 1 online resource (688 p.)
• Altri autori (Persone): PulsKen <1973->; HennigTeresa <1958->
• Disciplina: 005.5
• Soggetti: Business - Computer programs
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Includes index.
• Nota di contenuto: 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; ConclusionChapter 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 CodeDebugging 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 ElementThe 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 UsersThe 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
• Sommario/riassunto: 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 customizingInstructions and examples demonstrate how to customize the Ribbon using VBA, XML, Access, Excel, and WordCovers the relevant aspects of security, such as trust centers and digital certificatesPacked with real-world code examples that readers can immediately applyFeatures helpful references