functions in 'personal.xls'

[Russ]

It is my understanding that any subroutine saved in 'personal.xls'
will be accessible to all open workbooks. Does that also apply to
functions as well?

I have several recorded macros in the 'personal.xls' workbook and am
able to exceture them via shortcut keys from any other workbook,
however functions I manually define in the VB editior don't seem to be
accessible outside 'personal.xls'.

Is there some whay I can make functions globally available to all open
workbooks?

Thanks,
Russ

 

[Gord Dibben]

When entering functions stored in Personal.xls you must preface the function in
the active workbook like such.

=Personal.xls!myfunc(range) or similar depending upon args in myfunc.


Gord Dibben MS Excel MVP

 

[Ron de Bruin]

Or set a reference

See example on this page
http://www.rondebruin.nl/personal.htm

 

[Dave Peterson]

Or save the personal.* file as an addin (*.xla).

 

[Ron de Bruin]

For the OP

There is information how to do that also on this page
http://www.rondebruin.nl/personal.htm