MyAddin not Reacting

**jomili** · 08-16-2012, 05:34 PM

I've downloaded Ron DeBruin's "MyAddin.xlam", and loaded it with all of my favorite macros so I could share with my team. The menu appears just fine in my workbooks, but no matter which macro I choose to run, NOTHING happens. No error, no message, simply no reaction. I've shut down Excel, unistalled the addin, reinstalled it, and can't find any way to make it work.

Looking in the VBA editor, the MyAddin.xlam shows as RDBPersonal(MyAddin.xlam), whereas the other addins I have show as VBAProject(Addinname.xlam).

I'd appreciate any help I can get to get this thing running, as I've got some teammates who can really use the help. I would attach my add-in, but the attachment tool doesn't seem to allow it (when I go to select, it doesn't show as a file).

**Andy Pope** · 08-17-2012, 05:19 AM

try zipping the file first, xla(m) upload is not supported.

**jomili** · 08-17-2012, 08:52 AM

Thanks for that tip. I've zipped and attached it.

Since my last post I've made (limited) progress.

I wiped out MyAddin, downloaded a new copy, renamed it "OurAddin" (so I could tell the difference) Opened Excel, added it, verified Ron's macros worked. They did.

Shut down Excel, opened a workbook, verified Ron's macros worked. They did.

Clicked to edit "OurAddin". Copied my macros into the MacroModule under Ron's macros, updated the meno to access Ron's macros and my macros. Refreshed the menu, menu refresh worked fine. No macros (Ron's nor mine) would work.

Shut down Excel, reopened, macros still wouldn't work.

Commented out my macros, left Ron's. His worked.

Now I'm slowly going through and uncommenting a macro at a time. If I uncomment them all, nothing works, but so far each one works when I uncomment it. Maybe I've got too many macros in one module?

I also have a question: if some of my macros require different reference libraries, how do I ensure those are available to my users?

**Andy Pope** · 08-17-2012, 09:25 AM

All seems to work as expected.
You have to remove the option explicit because it will not compile otherwise.

Also the references to libraries need to be added, or you need to change your code to use Late binding and object references.

But the green arrow on the QAT displays your menu choices and reacts to the click.

**jomili** · 08-17-2012, 09:55 AM

Thanks Andy; I didn't even think about the "Option Explicit". That's an easy fix.

You mention "the references to libraries need to be added", but can I add the references in the "OurAddin.xlam" itself, so my users don't have to (and if so, how?), or is there a way to have the .xlam itself add the references to the user's Excel references?

You also mentioned "you need to change your code to use Late binding and object references." I've never understood what "late binding" is, so that's a tough one for me. Object references is easy enough.

Thanks so much for your help thus far. I sure appreciate it.

Thanks,
John