Add-In Problem
 

I want to create a .xla (add-in) file so that I can store the code that a
series of workbooks would use so that I don't have to change the code 50
times in 50 places if there is something that needs to be updated. But the
problem is that when the user first goes to "install" the add-in, they are
prompted to copy it to their personal add-in folder. I have told them to
decline to do that. Instead I want everyone to use the add-in that is in one
place, call it P:\library\add-in\. But perhaps the next time they go to use
the add in, it doesn't get loaded and they have to go pointing to it manually
again, because the add-in doesn't show up on their list of add-ins. It there
a way around this?