Menus or Menu Bars by Using Visual Basic

You can also modify existing menus or menu bars by using Visual Basic. 

If you create a macro to be used by other people, you can make it easy for them to use the macro by installing a custom menu command. As well, you can install the new menu command by means of an automatic procedure, so that all the users have to do is open the macro document. There are two ways you create an automatic procedure by creating an Auto Open macro in a module sheet, or by creating a Workbook Open event procedure. These are described in the sections that follow. 

In contrast to changes to menus made by using the Customize... command, menus and menu commands installed by using VBA are not saved when you quit Microsoft Excel. 

ADDING A MENU COMMAND BY MEANS OF AN AUTO OPEN MACRO 

In Excel 5/95, any macro with the name Auto Open will be run automatically whenever the workbook containing that macro is opened. You can still employ Auto Open procedures in Excel 97 or Excel 2000. 

---