LEADER 05166nam 2200649Ia 450 001 9910458637903321 005 20200520144314.0 010 $a1-281-20430-7 010 $a9786611204303 010 $a0-470-28852-3 035 $a(CKB)1000000000402375 035 $a(EBL)331665 035 $a(OCoLC)238572673 035 $a(SSID)ssj0000077669 035 $a(PQKBManifestationID)11107512 035 $a(PQKBTitleCode)TC0000077669 035 $a(PQKBWorkID)10060506 035 $a(PQKB)11748963 035 $a(MiAaPQ)EBC331665 035 $a(CaSebORM)9780470191118 035 $a(Au-PeEL)EBL331665 035 $a(CaPaEBR)ebr10225437 035 $a(CaONFJC)MIL120430 035 $a(EXLCZ)991000000000402375 100 $a20071210d2008 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aRibbonX$b[electronic resource] $ecustomizing the Office 2007 Ribbon /$fRobert Martin, Ken Puls, Teresa Hennig 205 $a1st edition 210 $aIndianapolis, IN $cWiley Pub.$dc2008 215 $a1 online resource (688 p.) 300 $aIncludes index. 311 $a0-470-19111-2 327 $aRibbonX; 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 327 $aConclusionChapter 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 327 $aWriting 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 327 $aThe 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 327 $aChapter 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 327 $aChapter 14: Customizing the Office Menu and the QAT 330 $aAs 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 606 $aBusiness$xComputer programs 608 $aElectronic books. 615 0$aBusiness$xComputer programs. 676 $a005.5 700 $aMartin$b Robert$f1972-$0191441 701 $aPuls$b Ken$f1973-$0892214 701 $aHennig$b Teresa$f1958-$0892215 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910458637903321 996 $aRibbonX$91992395 997 $aUNINA