I have a number of macros, both Subroutines (sub) and Function Routines
(Function) that may be applicable for use in any or many different workbooks.
I would like to store these where Excel (either Excel2003 or Excel 2007) can
always find them and use them when called either as function from within a
cell or as a subroutine from a macro button on the sheet. My goal is to have
only one place where I an edit and modify these routines where the changes
will be "universal" without have to copy to each workbook and thereby
proliferate many older copies when a change is made.
I have tried storing them in personal .xla, personal.xls or another named
addin. The function routine work from cells, but a subroutine call
alwaysgives the error that the routine cannot be found.
Is there a way to have Excel try to resolve references from personal.xla, or
anywhere else when there is a "missing" routine?
Thanks in advance for any help on this topic!!
-- jwm