Custom Functions in Personal.XLS
 

I have written several macros and run them in various worksheets from their
home in my personal.xls file. I can not get a custom function to work from
there, though. Is this not allowed? I have several that work well in an
individual worksheet, but they die when stored in personal. When I use the
function in a formula that way I get the #NAME error for the formula result.

Any ideas will be greatly appreciated!

Alan

Custom Functions in Personal.XLS
 

=PERSONAL.XLS!myFunc()

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan Cannon" wrote in message
...
I have written several macros and run them in various worksheets from
their
home in my personal.xls file. I can not get a custom function to work from
there, though. Is this not allowed? I have several that work well in an
individual worksheet, but they die when stored in personal. When I use the
function in a formula that way I get the #NAME error for the formula
result.

Any ideas will be greatly appreciated!

Alan

Custom Functions in Personal.XLS
 

Thanks, RP. That did the trick, as you knew it would, I'm sure.

For anyone else reading this thread, I also learned elsewhere that by
putting the functions into a blank spreadsheet and saving it as an add-in I
don't need to use the spreadsheet name, like Personal.xls!

Happy programming all!

"Bob Phillips" wrote in message
...
=PERSONAL.XLS!myFunc()

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alan Cannon" wrote in message
...
I have written several macros and run them in various worksheets from
their
home in my personal.xls file. I can not get a custom function to work
from
there, though. Is this not allowed? I have several that work well in an
individual worksheet, but they die when stored in personal. When I use
the
function in a formula that way I get the #NAME error for the formula
result.

Any ideas will be greatly appreciated!

Alan