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