O'Reilly logo

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® by John Green, Rob Bovey, Stephen Bullen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required