Custom Menus and Menu Bars

In this chapter you ll learn how to add a new command to a menu, how to add a new menu to a menu bar and how to create a whole new menu bar with separate menus and commands. In this way you can add new capabilities to Excel or even create a complete custom application. 

In earlier versions of Microsoft Excel, menu bars contained only menus, and toolbars only toolbuttons. Beginning with Excel 97, toolbuttons and menu items are both members of the class of CommandBarButton objects. Command bars can contain buttons or menus or both. In general, however, mixing buttons and menu commands on the same toolbar doesn t seem to be a good idea, so this chapter deals exclusively with menus and Chapter 19 with toolbars. 

---

Chapter 18 Creating Custom Menus and Menu bars... 

If you have written a number of related macros, you may even decide to create a custom menu bar with several custom menus, each containing custom commands. While both "Custom Menu Command" and "New Menu" can be... 

Figure 18.1 A custom menu bar with three menus Excel s built-in File and Edit menus...

---