Excel 2007 addin Macro Missing

[Ethan Strauss]

Hi,
I am quite new to Excel 2007. I have an addin with a Macro which I can not
access.
Details:
I wrote a Macro in VB in Excel 2007. The Macro runs.
I saved the file as a .xlsm and I can open that file an rerun the macro with
no problem. I now want to be able distribute it for others to use.
I saved the file as an Excel Addin (.xlam) in my addin folder()
I moved that file to my addin folder (C:\Documents and
Settings\myname\Application Data\Microsoft\AddIns).
I opened a new Excel 2007 document and looked for the macro (developer tab,
click on Macros), but I don't see it.
I went through Options, Addins, Manage Add ins and checked it. It now shows
up in my "Active Application Add-ins" list, but I still don't see the Macro
in my Macro list.
I checked the Trust Center and that location is trusted.

Does anyone know how to make a Macro available for others in Excel 2007?

Thanks!
Ethan

 

[Dave Peterson]

In xl2003, subroutines in addins don't show up in that dialog box (alt-f8). It
sounds like xl2007 works exactly the same way.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm

 

[Ethan Strauss]

Thanks!
I'll take a look at those.
Ethan

In xl2003, subroutines in addins don't show up in that dialog box (alt-f8). It
sounds like xl2007 works exactly the same way.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm