MACRO MENU

[Guest]

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?

 

[Guest]

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 here:
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.

 

[Guest]

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 here:
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.

 

[Guest]

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.

 

[David McRitchie]

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.

 

[David McRitchie]

Update to this month old thread. I have rebuilt a facsimile
of the old toolbar menu with a customized Quick Access Toolbar
(#qat) based on previous information in this thread using macros
from Ron de Bruin and by including my own lists of macros in the
sample from Ron's site. Macros to recreate the tree structure of
the menu from older Excel versions (also works for Excel 2007) can
be found on my site. See
http://www.mvps.org/dmcritchie/excel/excel2007.htm#qat