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

On Thu, 28 Jun 2007 11:06:33 -0700, Russ wrote:

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

Or set a reference

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




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
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

On Thu, 28 Jun 2007 11:06:33 -0700, Russ wrote:

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

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



Ron de Bruin wrote:

Or set a reference

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
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

On Thu, 28 Jun 2007 11:06:33 -0700, Russ wrote:

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


--

Dave Peterson

For the OP

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

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
Or save the personal.* file as an addin (*.xla).



Ron de Bruin wrote:

Or set a reference

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
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

On Thu, 28 Jun 2007 11:06:33 -0700, Russ wrote:

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


--

Dave Peterson