functions in 'personal.xls'
 

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

functions in 'personal.xls'
 

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

functions in 'personal.xls'
 

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

functions in 'personal.xls'
 

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

functions in 'personal.xls'
 

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