Over time I created a number of "reusable" macros which I'd like to make automatically accessible for other workbooks I'm using. The only possibilities I've come across is storing those macros in e.g. a Personal.xls file in the XLSTART Directory of Excel or to store them as an Add-in in a xlam file. The downside of all of this (if I understand) is, that functions can only be called via RUN with no possibility to pass Information back and forth to the calling macro. And if I understand it correctly, an instantiating of a class defined in this library is not possible at all.
So the only Advantage - if at all - would then be to have such a library open when any workbook is open in order to copy / past code to the individual workbook?
I wonder whether there are (other) possibilities to use functions and classes defined in a library with passing Information back and forth?