Microsoft Office Tutorials and References
In Depth Information
Determining the Most Appropriate User Interface
To solve this problem, I created a new version of PUP specifically for Excel 2007 and later.
With Excel 2010 (and Excel 2007), some of these decisions are irrelevant. Custom menus and
toolbars are, for all intents and purposes, obsolete. Consequently, developers must learn how to
work with the Ribbon.
Excel provides several features that are relevant to user interface design:
h Ribbon customization
h Shortcut menu customization
h Shortcut keys
h Custom dialog boxes (UserForms)
h Controls (such as a ListBox or a CommandButton) placed directly on a worksheet