Add-in not showing in Macro's list

[samfolds]

Hello,

I have recently discovered the beauty of add-ins, but I've got a small problem :

I saved my add-in workbook as an xla in the appropriate folder and I enabled the add-in in the workbooks, but when I open a new workbook, the sub I had made does not appear in the Macro's list (Alt+F8).

When I go in the VBA environment (Alt+F11), I see my sub in the workbook [Name].xla.xls...

Is there anyway I can make the sub appear in the Macro's list?

Thanks in advance!

 

[samfolds]

Thank you mooseman for that insight. I'm already trying to learn how to make a simple toolbar.

It is good to know that Add-in type workbooks do not show the macros in the macro list...

Thanks again for all your support, it was helpful and appreciated.

Sam

PS : the code given by Weaver worked just fine and it even speeded up my macro by at least 50%. Thanks