RibbonX customizing the Office 2007 Ribbon

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 as...

Descripción completa

Detalles Bibliográficos
Autor principal: Martin, Robert, 1972- (-)
Otros Autores: Puls, Ken, 1973-, Hennig, Teresa, 1958-
Formato: Libro electrónico
Idioma:Inglés
Publicado: Indianapolis, IN : Wiley Pub c2008.
Edición:1st edition
Materias:
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627654606719
Tabla de Contenidos:
  • 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