Are you talking about actually creating custom menus that went into the
regular menu bar along with "File Edit .... Help" ? and you want the same
ability, but need it with the Ribbon?

Without resorting to new technology, I discovered (quite by accident, I
assure you) that if you set up that type of custom menu in an Excel 2003 file
and open it up in Excel 2007, the custom menu(s) show up in the 'Add-Ins'
tab. Haven't tried starting out in an Excel 2007 file with same, pre-2007
type custom menu code.

Meanwhile, Ron DeBruin has info he
http://www.rondebruin.nl/ribbon.htm

and you can find a ribbon customizer at
http://www.pschmid.net/index.php
He has a free, limited function version and a reasonably price professional
version that will allow you to create your own ribbons.


"REDANDY" wrote:

When i was using excel 2003 i set up many macros to run some reports.
i was able to set up a drop down menu and assign a specific macro to each
menu item on the drop down menu (25 menu items)

How do i set up a drop down menu to run the individual menu items now in
2007 excel?