View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Edwin Kelly Edwin Kelly is offline
external usenet poster
 
Posts: 13
Default Why Would Add-In Modules Not Be Accessible?

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?

--
Edwin Kelly
Houston, TX