Why Would Add-In Modules Not Be Accessible?

[Edwin Kelly]

I have a number of Excel reports that are running on a server at work on set
frequencies. I created an add-in for a generic print routine so all the
reports could use it to do the automated printing. The add-in is loaded in
Excel on the server and shows in the list of add-ins.
What is happening, is that some workbooks do not recognize the add-in
anymore (ie., "macro not found"). It does not affect all workbooks though.
I can open the VB Editor and see the add-in listed in the Project Explorer.
I can open it and see the code too.

The only way to fix it for these workbooks is to copy the code and insert it
into a module in the workbook.

Any idea why this is happening and how to fix it so it only uses the add-in
macros?

 

[Dave Peterson]

I don't have a solution, but the first thing I'd check is the thing that
initiates the macro.

Is the macro assigned to a button on a toolbar or a worksheet?

If yes, look at that assignment and see if you're pointing to the correct
workbook. I'm guessing that it's pointing to an old location/workbook or even
the current workbook instead of the addin.

 

[NFL]

Is the security setting on the excel workbook file set to Medium or Low?