Thanks Jerry, ( posted in microsoft.public.excel.misc)
That looks like it will do the trick, the only problem is that
I called my personal.xls workbook by another name, but I do
see that after I copied over my excel.xlb (from Excel 2000)
over to new system and opened it with Excel that an addons
did appear on the menu bar and that the menu was available
by my name 'My Tools' on "Menu Commands" and the toolbar
buttons on the "Custom Toolbars". Horrible way to go though
means two extra clicks. About 140 items to rename or something
-- I'll see if I can rename my current personal.xls to the old name
or perhaps there is an XLM file that can be edited if it got saved
can't tell what's going on while the AV program is running.
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"REDANDY" wrote in message ...
Yes, this menu is on the tool bar and was created with the customized
commands under customize on the tool bar and under commands with new menu and
under macros with custom menu item.

"JLatham" wrote:

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?