Chapter 17. Command Bars

The ability to manipulate menus in Microsoft Excel is very important when creating custom add-ins. By trapping the appropriate events in an add-in, the add-in can automatically add the appropriate menu items, making the add-in appear to be a standard part of Excel. In this chapter, you’ll learn about the various objects associated with menus and toolbars and how to add new menu items, modify existing menu items, and undo the changes your application made, to restore Excel to its unmodified state.

Identifying Parts of the Menu System

Microsoft has developed a very flexible object model that combines menus, command buttons, combo boxes, and pop-up menus into a single ...

Get Microsoft® Office Excel 2003 Programming Inside Out 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.