Custom Functions
Another way (I wouldn't use it as a general solution, though) is to go into the
VBE and use Tools|references to that personal.xls workbook.
But this would require that every workbook that you want to use these functions
(without the workbook name) would have to have a reference to this
personal.xls's project.
Sloth wrote:
I have several functions in my personal workbook. Is there a way to call
these functions without using the "PERSONAL.XLS!" tag in front of it?
so instead of using
=PERSONAL.XLS!newfunction(A1)
I would like to be able to use
=newfunction(A1)
without copying the VBA function into the current workbook.
--
Dave Peterson
|