Thread: Custom Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Custom Function

=personal.xls!Myfunctionname(arg1, arg2)

Or put them in an Addin and load the addin. Then you won't need the
filename.

--
Regards,
Tom Ogilvy


"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?'