Excel macro does not show up in Macro list

I made a macro, works fine, shows up in the macro drop-down list.
I saved that workbook as an add-in.
Now, opening a new workbook, Alt-F11 and I can see the add-in, and my code is right there in the module where it should be.
But - when I click on the Macros drop-down, it's empty.
If I manually type the name of my macro in to the macro list box, it runs.
Why does it not show up?
It is not private, it starts like this:

Please Login or Register  to view this content.

Thanks in advance -
Dan

Hi Dan,

welcome to the forum.
As per my knowledge, your current workbook has your existing workbook as an add-in and hence it is there as an installation but it is not there as macro and hence should not be showing because your current workbook never had this. This is tricky but I hope u got it.

Regards,
DILIPandey
<click on below * if this helps>

Hi Dan,

When you open the Macro dialog (Alt + F8) make sure the All Open Workbooks is selected from the Macros in listbox.

HTH

Robert

Hi dnmeeks, did you checked my post#2 ?


Regards,
DILIPandey
<click on below * if this helps>

Okay.. let me summarize it here:-
-You created a macro (vba) and you saved the workbook as xla.
-now you wish to use this macro (or say the workbook containing macro) as an add-in in some other workbook.
-you opened your other workbook and browsed xla file and installed it. Now it should appear as a button (menu / ribbon bar) if you designed it that way or whatever customization you done to use that. If you wish you can search internet on how to transfer xla on menu / ribbon bar

You cannot see :-
the macro if your bring macro list box (alt + f8), see below what Microsoft is saying:-
"Excel Add-in (XLA) is really an Excel Workbook (*.xls) that does not contain any worksheets. The only part of the file that is used by Excel is the Visual Basic for Applications (VBA) project sub-storage, which contains the add-in (VBA) code.
http://support.microsoft.com/kb/268016"

You can SEE:-
if you press Alt + F11 (VB Editor), you should find your xla workbook listed on left side.

Below method can be used to convert an xla back to xlsx / xls :-
http://support.microsoft.com/kb/211561

hope this helps

Regards,
DILIPandey
<click on below * if this helps>

but the macros do NOT show up in the macros drop-down.

why you want macro to show up, when you have your macro in personal.xls you can still use that.
and for add-in, so that it appears every time, did you created that add-in to appear as a menu / ribbon button ?

Regards,
DILIPandey
<click on below * if this helps>

I am having the same problem. I made changes to an add-in that was currently on my ribbon. It forced me to save it as a new name. Then I went into the add-in manager and clicked the check. It is now showing up in vb where I can run the macro, but it is not showing up in the drop down list so that I can run it from excel.

I have since fixd it somehow.

I am not sure which of these fixed it. So maybe this will help

Renamed the file
Moved it out of the add in directory
closed excel
moved it back into the add indirectory
opened the excel and went into the window options and into the addin go
Finally it was not there so I searched to the add in and added it.
from there i was able to add the macro back to the ribbon.

jgross,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

Macros in add-ins do not show up in the macros dialog. You need to provide a way to run them - usually through a menu system of some kind (eg customising the Ribbon).