ADDIN: want item in macro menu

[Emanresux]

Hello All,

It's been a really long time since I used VBA and have just been surprised by a colleague who wanted some code. Added to this I am trying to get my head around 2010's new layout. The story is this:

I have written the code and now want to distribute it as an ADD-IN in order that the macro will be accessible from the View->Macros window in any workbook. So, the code is written in a module of a workbook which I have then saved as a .xlam format. I have added the ADD-IN to Excel from the Options dialog and it now appears in the "Active Application Add-ins" list. The problem is that the macro name does not appear in the Macro's list.

I little searching on the net seem to point towards a solution which involves coding a custom-menu-bar item which seems really over the top....

is there a simpler way to distribute a macro so that it is available in every open workbook?

I hope this is clear....

Cheers,
G

 

[Emanresux]

you can save the macro in you "personal macro workbook" then it will be available all the time.