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

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

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