How do I create custom menus and toolbars in Excel 97?
In Excel 97, MenuBars and Toolbars are both part of the new CommandBars object model. The VBA code required to create custom menus and toolbars is very similar, enough so that it is possible to create one table-driven solution that will build both toolbars and menu bars at the same time (see the Baarns Developer JumpStart for more details). The following code sample shows how to create a simple custom menu bar using the CommandBars object model. In order to run this code, you must set a reference in the Visual Basic Editor (VBE) to the Microsoft Office 8.0 object library (Choose Tools/References from the VBE menu and put a check mark beside this name).
