Chapter 8. Advanced Command Bar Handling

This chapter starts off by covering some best practices for command bar design. Then we introduce our table-driven command bar building methodology. This feature, which you can easily add to your own applications, removes most of the difficulties associated with building and maintaining nontrivial custom command bars. We show you how to create and use custom icon/mask file combinations in Excel 2002 and higher (a feature also supported by the command bar builder). We then finish up by explaining how to hook CommandBarControl events in order to intercept clicks from CommandBarControls in ways that are not possible using a simple OnAction macro assignment.

Note

Whenever we use the noun control in this chapter, ...

Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.