Excel Menu Manager

Christopher Rath

2006-10-22

Menu Manager Skeleton

This menu manager skeleton provides a starting point for a new Add-In to be created, where that Add-In will place itself on the menu bar and also create a toolbar button.

Installation Instructions

The following steps are a attempt to describe the complete process followed to use this skeleton in creation of an Excel Add-In.

1. Create a new Excel workbook.
2. Save the workbook, giving it the name your final Add-In .xla file should have, except this version is saved as an .xls file (I also put the word "template" in the filename to make it very clear that this is not the final Add-In).
3. Copy the Prod and EventClass modules into the new workbook.
4. Copy the "ThisWorkbook" code into the new workbook.
5. Set the constant values:
   • AddInNm - Name of your Add-In; this will be used to create a Windows Registry entry.
   • CmdBarNm - The name you will give the toolbar embeded within your Add-In.
   • ButtonNm - The name you will give the toolbar button that invokes your Add-In.
   • MyMenuNm - The short name you will give the menu item that the Add-In places on the "My..." menu (this name is not seen by the user).
   • MyMenuCaption - The text that will appear as the menu item.
   • MyMenuOnAction - The VBA macro to be called when the menu item is selected.
6. Add your code to this Prod module.
7. Create a button bar and button for your Add-In.
8. Attach the button bar to the new workbook.
9. Save the new workbook.
10. Lastly, perform a Save As, choosing the file type as an Excel Add-In, giving it the final name you want for the Add-In.
11. Close the workbook.
12. Delete the Add-In's button bar (Tools->Customize, choose the toolbar and the press [Delete]).
13. Restart Excel, and then load the Add-In (Tools->Add Ins...).
14. Test the Add-In.

Skeleton Add-In

The Add-In can be downloaded from here. The instructions above are also embedded within the Prod VBA module.

Copyright & Licensing

Note, the menu manager skeleton is Copyright ©2006 Christopher Rath. Permission is granted for any use of this skeleton by others as long as this copyright statement is retained, other due and proper credit is provided to the author (e.g., don't claim you wrote this template), and the LGPL license is respected.   This package is free software; you can redistribute it and/or modify it under the terms of version 2.1 of the GNU Lesser General Public License as published by the Free Software Foundation. See the LGPL license on the GNU.org website.  This package is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE; on an “AS IS,” “WHERE IS” and “WITH ALL FAULTS” basis.