Book description
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
Table of contents
- Copyright
- About the Authors
- Credits
- Acknowledgments
- Introduction
-
I. The Building Blocks for a Successful Customization
- 1. An Introduction to the Office User Interface
-
2. Accessing the UI Customization Layer
-
2.1. Accessing the Excel and Word Ribbon Customization Layers
- 2.1.1. What's New in Excel and Word Files?
- 2.1.2. Creating a Ribbon Customization with Notepad
-
2.1.3. Using the Microsoft Office 2007 Custom UI Editor to Modify Your UI
- 2.1.3.1. Installing Microsoft .NET Framework 2.0 for Windows XP Users
- 2.1.3.2. Installing the Microsoft Office 2007 Custom UI Editor
- 2.1.3.3. Using the CustomUI Editor to Customize the Ribbon
- 2.1.3.4. Storing Customization Templates in the CustomUI Editor
- 2.1.3.5. Some Notes About Using the CustomUI Editor
- 2.1.4. XML Notepad
- 2.1.5. A Final Word on Excel and Word Customizations
- 2.2. Microsoft Access Customizations
- 2.3. Conclusion
-
2.1. Accessing the Excel and Word Ribbon Customization Layers
-
3. Understanding XML
- 3.1. What Is XML and Why Do You Need It?
- 3.2. Essential Background
- 3.3. The Core XML Framework
- 3.4. The customUI Element
- 3.5. The ribbon Element
- 3.6. The tabs Element
- 3.7. The tab Element
- 3.8. The group Element
- 3.9. Conclusion
-
4. Introducing Visual Basic for Applications (VBA)
- 4.1. Getting Started with Visual Basic for Applications (VBA)
- 4.2. Recording Macros for Excel and Word
- 4.3. Subprocedures versus Functions
- 4.4. VBA Coding Techniques
- 4.5. Writing Your Own Code
- 4.6. Debugging Your Code
- 4.7. Error Handling
- 4.8. Working with Arrays
- 4.9. Conclusion
- 5. Callbacks: The Key to Adding Functionality to Your Custom UI
-
6. RibbonX Basic Controls
-
6.1. The button Element
- 6.1.1. Required Attributes of the button Element
- 6.1.2. Optional Static and Dynamic Attributes with Callback Signatures
- 6.1.3. Allowed Children Objects of the button Element
- 6.1.4. Parent Objects of the button Element
- 6.1.5. Graphical View of button Attributes
- 6.1.6. Using Built-in button Controls
- 6.1.7. A button Idiosyncrasy: The showLabel Attribute
- 6.1.8. Creating Custom button Controls
-
6.2. The checkBox Element
- 6.2.1. Required Attributes of the checkBox Element
- 6.2.2. Optional Static and Dynamic Attributes with Callback Signatures
- 6.2.3. Allowed Children Objects of the checkBox Element
- 6.2.4. Parent Objects of the button Element
- 6.2.5. Graphical View of checkBox Attributes
- 6.2.6. Using Built-in checkBox Controls
- 6.2.7. Creating Custom Controls
-
6.3. The editBox Element
- 6.3.1. Required Attributes of the editBox Element
- 6.3.2. Optional Static and Dynamic Attributes with Callback Signatures
- 6.3.3. Allowed Children Objects of the editBox Element
- 6.3.4. Parent Objects of the editBox Element
- 6.3.5. Graphical View of editBox Attributes
- 6.3.6. Using Built-in editBox Controls
- 6.3.7. Creating Custom Controls
-
6.4. The toggleButton Element
- 6.4.1. Required Attributes of the toggleButton Element
- 6.4.2. Optional Static and Dynamic Attributes with Callback Signatures
- 6.4.3. Allowed Children Objects of the toggleButton Element
- 6.4.4. Parent Objects of the toggleButton Element
- 6.4.5. Graphical View of toggleButton Attributes
- 6.4.6. Using Built-in toggleButton Controls
- 6.4.7. Creating Custom Controls
- 6.5. Conclusion
-
6.1. The button Element
-
7. comboBox and dropDown Controls
-
7.1. The item Element
- 7.1.1. Required Attributes of the item Element
- 7.1.2. Optional Static and Dynamic Attributes with Callback Signatures
- 7.1.3. Allowed Children Objects of the item Element
- 7.1.4. Parent Objects of the item Element
- 7.1.5. Graphical View of item Attributes
- 7.1.6. Using Built-in Controls
- 7.1.7. Creating Custom Controls
-
7.2. The comboBox Element
- 7.2.1. Required Attributes of the comboBox Element
- 7.2.2. Optional Static and Dynamic Attributes withCallback Signatures
- 7.2.3. Allowed Children Objects of the comboBox Element
- 7.2.4. Parent Objects of the comboBox Element
- 7.2.5. Graphical View of comboBox Attributes
- 7.2.6. Using Built-in Controls
- 7.2.7. Creating Custom Controls
-
7.3. The dropDown Element
- 7.3.1. Required Attributes of the dropDown Element
- 7.3.2. Optional Static and Dynamic Attributes with Callback Signatures
- 7.3.3. Allowed Children Objects of the dropDown Element
- 7.3.4. Parent Objects of the dropDown Element
- 7.3.5. Graphical View of dropDown Attributes
- 7.3.6. Using Built-in Controls
- 7.3.7. Creating Custom Controls
- 7.4. Conclusion
-
7.1. The item Element
- 8. Custom Pictures and Galleries
-
9. Creating Menus
-
9.1. The menu Element
- 9.1.1. Required Attributes of the menu Element
- 9.1.2. Optional Static and Dynamic Attributes with Callback Signatures
- 9.1.3. Allowed Children Objects of the menu Element
- 9.1.4. Parent Controls of the menu Element
- 9.1.5. Graphical View of menu Attributes
- 9.1.6. Using Built-in Controls
- 9.1.7. Creating Custom Controls
-
9.2. The splitButton Element
- 9.2.1. Required Attributes of the splitButton Element
- 9.2.2. Optional Static and Dynamic Attributes with Callback Signatures
- 9.2.3. Allowed Children Objects of the splitButton Element
- 9.2.4. Parent Objects of the splitButton Element
- 9.2.5. Graphical View of splitButton Attributes
- 9.2.6. Using Built-in Controls
- 9.2.7. Creating Custom Controls
-
9.3. The dynamicMenu Element
- 9.3.1. Required Attributes of the dynamicMenu Element
- 9.3.2. Optional Static and Dynamic Attributes with Callback Signatures
- 9.3.3. Allowed Children Objects of the dynamicMenu Element
- 9.3.4. Parent Objects of the dynamicMenu Element
- 9.3.5. Graphical View of dynamicMenu Attributes
- 9.3.6. Using Built-in Controls
- 9.3.7. Creating Custom Controls
- 9.4. Conclusion
-
9.1. The menu Element
-
10. Formatting Elements
-
10.1. The box Element
- 10.1.1. Required Attributes of the box Element
- 10.1.2. Optional Static and Dynamic Attributes with Callback Signatures
- 10.1.3. Allowed Children Objects of the box Element
- 10.1.4. Parent Objects of the box Element
- 10.1.5. Graphical View of box Attributes
- 10.1.6. Using Built-in box Elements
- 10.1.7. Creating Custom box Elements
-
10.2. The buttonGroup element
- 10.2.1. Required Attributes of the buttonGroup element
- 10.2.2. Optional Static and Dynamic Attributes with Callback Signatures
- 10.2.3. Allowed Children Objects of the buttonGroup Element
- 10.2.4. Parent Objects of the buttonGroup Element
- 10.2.5. Graphical View of a buttonGroup
- 10.2.6. Using Built-in buttonGroup Elements
- 10.2.7. Creating Custom buttonGroup Elements
-
10.3. The labelControl Element
- 10.3.1. Required Attributes
- 10.3.2. Optional Static and Dynamic Attributes with Callback Signatures
- 10.3.3. Allowed Children Objects of the labelControl Element
- 10.3.4. Parent Objects of the labelControl Element
- 10.3.5. Graphical View of a labelControl
- 10.3.6. Using Built-in labelControl Elements
- 10.3.7. Creating Custom labelControl Elements
-
10.4. The separator Element
- 10.4.1. Required Attributes of the separator Element
- 10.4.2. Optional Static and Dynamic Attributes with Callback Signatures
- 10.4.3. Allowed Children Objects of the separator Element
- 10.4.4. Parent Objects of the separator Element
- 10.4.5. Graphical View of a Separator
- 10.4.6. Using Built-in separator Elements
- 10.4.7. Creating Custom separator Elements
-
10.5. The menuSeparator Element
- 10.5.1. Required Attributes of the menuSeparator Element
- 10.5.2. Optional Static and Dynamic Attributes with Callback Signatures
- 10.5.3. Allowed Children Objects of the menuSeparator Element
- 10.5.4. Parent Objects of the menuSeparator Element
- 10.5.5. Graphical View of the menuSeparator Element
- 10.5.6. Using Built-in menuSeparator Elements
- 10.5.7. Creating Custom menuSeparator Elements
- 10.6. Conclusion
-
10.1. The box Element
-
11. Using Controls and Attributes to Help Your Users
- 11.1. The dialogBoxLauncher Element
- 11.2. The keytip Attribute
- 11.3. screentip and supertip Attributes
- 11.4. Overwriting Built-in Control Attributes
- 11.5. Conclusion
-
II. Advanced Concepts in Ribbon Customization
- 12. Advanced VBA Techniques
- 13. Overriding Built-in Controls in the Ribbon
-
14. Customizing the Office Menu and the QAT
- 14.1. Adding Items to the Office Menu
-
14.2. Adding Items to the QAT
- 14.2.1. Customization Overview
- 14.2.2. Adding Custom and Built-in Commands to the QAT
- 14.2.3. Adding Custom and Built-in Groups to the QAT
- 14.2.4. Repurposing QAT Controls
- 14.2.5. Table-Driven Approach for QAT Customization (Excel and Word)
- 14.2.6. Table-Driven Approach for QAT Customization (Access)
- 14.2.7. QAT Caveats
- 14.3. Conclusion
- 15. Working with Contextual Controls
-
16. Sharing and Deploying Ribbon Customizations
- 16.1. Excel Deployment Techniques
- 16.2. Word Deployment Techniques
- 16.3. Sharing Ribbon Items Across Files (Word and Excel)
- 16.4. Deploying Word and Excel Solutions Where Multiple Versions of Office are in Use
- 16.5. Access Deployment Techniques
- 16.6. Conclusion
-
17. Security In Microsoft Office
- 17.1. Security Prior to Office 2007
- 17.2. Macro-Enabled and Macro-Free File Formats
- 17.3. The Trust Center
- 17.4. Digital Certificates
- 17.5. Conclusion
-
A. Tables of RibbonX Tags
- A.1. How to Use This Appendix
- A.2. Ribbon Container Elements
-
A.3. Ribbon Control Elements
- A.3.1. box Element
- A.3.2. button Element
- A.3.3. buttonGroup Element
- A.3.4. checkBox Element
- A.3.5. comboBox Element
- A.3.6. dialogBoxLauncher Element
- A.3.7. dropDown Element
- A.3.8. dynamicMenu Element
- A.3.9. editBox Element
- A.3.10. gallery Element
- A.3.11. item Element
- A.3.12. labelControl Element
- A.3.13. menu Element
- A.3.14. menuSeparator Element
- A.3.15. separator Element
- A.3.16. splitButton Element
- A.3.17. toggleButton Element
- B. Tables of Tab and Group idMso Names
- C. imageMso Reference Guide
- D. Keytips and Accelerator keys
- E. RibbonX Naming Conventions
- F. Where to Find Help
Product information
- Title: RibbonX: Customizing the Office 2007 Ribbon
- Author(s):
- Release date: January 2008
- Publisher(s): Wiley
- ISBN: 9780470191118
You might also like
book
VSTO 3.0 for Office 2007 Programming
Get to grips with Programming Office 2007 using Visual Studio Tools for Office A step-by-step guide …
book
Microsoft® Offic Excel® 2007 Visual Basic® for Applications Step by Step
Quickly teach yourself how to automate tasks and create custom spreadsheet solutions with Excel 2007 Visual …
book
Programming Applications for Microsoft® Office Outlook® 2007
Get the definitive guide to learning how to exploit the built-in functionality in Outlook 2007. Written …
book
Professional Outlook® 2007 Programming
Written by one of the most popular and knowledgeable Microsoft Outlook MVPs, this book fills a …