Adding Menu \ Commandbar to Excel Spreadsheet

[mdav2]

I need to add a new menu called "Reports" with say three options
"All","Income","Expenditure". I then want to run a macro when the user
selects one of the menu options.

Reports
All (run macro 1)
Income (run macro 2)
Expenditure (run macro 3)

I think it is something under commandbars but can't quite find the right
syntax.

Can someone shed some light.

 

[Hasit]

The way I would do it is:

1. TOOLS
2. CUSTOMIZE
3. Select the COMMAND tab
4. At the bottom of the list is NEW MENU
5. Drag and drop this item onto your toolbar
6. Rename it as REPORTS
7. Click on the MACROS entry under the COMMAND tab
8. Select the macro you want (e.g.macro1) and drag it to the newly created menu. Drop it below the menu (it should expand showing you a blank box)
9. Repeat for as many macros as you have
10. Click on CLOSE
11. Enjoy.

p.s. if you want meaningful names for your macros such as "Reports" etc, you can either rename them once you have dragged them to the menu or before (i.e. the macro name itself).