RibbonX : customizing the Office 2007 Ribbon / Robert Martin, Ken Puls, Teresa Hennig.

Format:

Book

Author/Creator:

Martin, Robert, 1972-

Contributor:

Puls, Ken, 1973-

Hennig, Teresa, 1958-

Language:

English

Subjects (All):

Business--Computer programs.

Business.

Microsoft Office.

Physical Description:

1 online resource (688 p.)

Edition:

1st edition

Place of Publication:

Indianapolis, IN : Wiley Pub., c2008.

Language Note:

English

System Details:

text file

Summary:

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

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

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

Notes:

Includes index.

ISBN:

9786611204303

9781281204301

1281204307

9780470288528

0470288523

OCLC:

238572673