I have developed an Excel Add-In, mainly for my personal use. I have added buttons to the ribbon to fire the macros. I feel my add-in is much more mature now than when I first started into this. It's to the point where I'd like to share the add-in with a colleague.
Here's my issue; I want it to be clearly communicate the macros that need to be linked to ribbon buttons. The first picture shows what I intend to have, procedures listed with the "CustomAddIn_" prefix.
The second picture shows what I cannot figure out... there are also procedures listed here that no longer exist in the add-in (have been commented out or removed altogether). I see that these are prefixed with a '. Any ideas what's going on here? I would like to remove these from the "Choose commands from \ Macros" list box.
Thanks!
I asked this question a little while back and feel I owe an update to future readers. I wasn't ever able to replicate the problem but David's answer got me to a solution:
Since the error seemed to be related to some kind of copy of the add-in file (my own doing at some point), I completely recreated the add-in. I copied all the code out of the modules into notepad files, added modules into a new excel file, copied in the code then drag and dropped the userforms from one project to another. Saved as xlam. That worked for me.
