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


I posted this in the General Questions area and I think it should have been
here so here it is ... again.

I have a number of Excel reports that are running on a server at work on set
frequencies (typically daily). 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.
They all used to work fine in the past.
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 new 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