I've been working on a project for my team at work to use. The Excel 2003 spreadsheet is on an NT NFS so they can all use it. I like XLAs, but one annoying thing about them is it seems that they don't seem to be workbook dependent. Installing it for one installs it for the rest, and vice versa. With other languages at compile time you can easily link libraries for specific source files.
I was wondering is it possible to have workbook dependent Excel VBA custom libraries and how to do this? Thanks
The solution I went with was to write my own custom code for loading and unloading add-ins depending on which workbooks are opened. This was painful but it accomplished the functionality I desired perfectly. So that they could be shared by everybody, I put them on a NFS and made them read-only. When I want to change the libraries, I open them for write briefly.