Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO MENU
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO MENU
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO MENU
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO MENU
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO MENU
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
MACRO MENU
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem assigning macro to menu button | Excel Worksheet Functions | |||
Can I add a Macro to right-click Menu? | Excel Discussion (Misc queries) | |||
Assign macro name to menu command w/o using workbook name | Excel Discussion (Misc queries) | |||
How do I add a macro to a custom menu? | Excel Discussion (Misc queries) | |||
"Macro" not available on "Tools" Menu | Setting up and Configuration of Excel |