PERSONAL.XLS won't take custom functions
 

I am developing some custom funtions that I want to use in all my
workbooks. When I put the code in a module for an individual workbook
it works fine. When I put the code in PERSONAL.XLS it does not work.
I try to use the formula and I get a #NAME error. Any suggestions how
I get this thing working?


--
OxMan
------------------------------------------------------------------------
OxMan's Profile: http://www.excelforum.com/member.php...o&userid=26392
View this thread: http://www.excelforum.com/showthread...hreadid=396727

PERSONAL.XLS won't take custom functions
 

=personal.xls!MyFunction(a1,b1,c1)

If you save your personal.xls workbook as an addin, then you don't need this
"prefixing" stuff.

But you won't see macros in that .xla (or any .xla) in the Tools|macro|macros
dialog.

OxMan wrote:

I am developing some custom funtions that I want to use in all my
workbooks. When I put the code in a module for an individual workbook
it works fine. When I put the code in PERSONAL.XLS it does not work.
I try to use the formula and I get a #NAME error. Any suggestions how
I get this thing working?

--
OxMan
------------------------------------------------------------------------
OxMan's Profile: http://www.excelforum.com/member.php...o&userid=26392
View this thread: http://www.excelforum.com/showthread...hreadid=396727

--

Dave Peterson