macros in my custom xla Addin - how to make visible in Macro menu?

R

Rich

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
 
R

Ron de Bruin

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/index.php?d=endownloadcommandbars

How to customize menus and menu bars in Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&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
 
R

Rich

thanks for the references.

Ron de Bruin said:
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/index.php?d=endownloadcommandbars

How to customize menus and menu bars in Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top