Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros in my custom xla Addin - how to make visible in Macro menu?
I created a number of VBA procedures (macros) which I saved to a .xla file.
I need to use these macros in various workbooks. I added the xla to the Addins list, but I don't see a list of the macros from this addin in the Macro menu. Is there a way to make these macros visible in the macro menu? How to do this? Thanks, Rich |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros in my custom xla Addin - how to make visible in Macro menu?
Hi Rich
This is not possible You must make a nice menu for your add-in Excel 97-2003 Debra Dalgleish's (Toolbar example from Dave Peterson) http://www.contextures.com/xlToolbar02.html Creating Custom Menus (John Walkenbach) http://www.j-walk.com/ss/excel/tips/tip53.htm Ole P. Erlandsen's Web Site (Example workbooks) http://www.erlandsendata.no/english/...oadcommandbars How to customize menus and menu bars in Excel http://support.microsoft.com/default...02&Product=xlw Excel 2007 In Excel 2007 check out this example for your PERSONAL.XLSB http://www.rondebruin.nl/qat.htm If you want to change the ribbon check out this page http://www.rondebruin.nl/ribbon.htm Note: It is not possible to use XML to create a menu for your PERSONAL.XLSB. Use the QAT example then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich" wrote in message ... I created a number of VBA procedures (macros) which I saved to a .xla file. I need to use these macros in various workbooks. I added the xla to the Addins list, but I don't see a list of the macros from this addin in the Macro menu. Is there a way to make these macros visible in the macro menu? How to do this? Thanks, Rich |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros in my custom xla Addin - how to make visible in Macro m
thanks for the references.
"Ron de Bruin" wrote: Hi Rich This is not possible You must make a nice menu for your add-in Excel 97-2003 Debra Dalgleish's (Toolbar example from Dave Peterson) http://www.contextures.com/xlToolbar02.html Creating Custom Menus (John Walkenbach) http://www.j-walk.com/ss/excel/tips/tip53.htm Ole P. Erlandsen's Web Site (Example workbooks) http://www.erlandsendata.no/english/...oadcommandbars How to customize menus and menu bars in Excel http://support.microsoft.com/default...02&Product=xlw Excel 2007 In Excel 2007 check out this example for your PERSONAL.XLSB http://www.rondebruin.nl/qat.htm If you want to change the ribbon check out this page http://www.rondebruin.nl/ribbon.htm Note: It is not possible to use XML to create a menu for your PERSONAL.XLSB. Use the QAT example then -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Rich" wrote in message ... I created a number of VBA procedures (macros) which I saved to a .xla file. I need to use these macros in various workbooks. I added the xla to the Addins list, but I don't see a list of the macros from this addin in the Macro menu. Is there a way to make these macros visible in the macro menu? How to do this? Thanks, Rich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable custom menu item based on visible cells | Excel Programming | |||
Macros Referenced in Custom Menu Fail after Save | Excel Programming | |||
create custom menu with addin connect/disconnect | Excel Programming | |||
make a custom menu available to other users of | Excel Programming | |||
VBA-Make Custom Menu Item Fire | Excel Programming |