Edgar,

You need to precede the macro with the workbook name,

=Personal.xls!myFunc(myparam)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Edgar" wrote in message
...
Hi

I have a couple of custom functions that i have saved in
my Personal.xls workbook.

Is there a way of making these public so i can call them
from any workbook?

When I try calling it from a workbook I get the
message 'Name?'