functions in 'personal.xls'

  • Thread starter Thread starter Russ
  • Start date Start date
R

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
 
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
 
Back
Top