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

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

You need to qualify the macro name with the workbook name (unless the
file is an add-in). E.g.,

=Personal.xls!MyFunction


In article ,
"Edgar" wrote:

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

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

make it an add-in

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

How easy is it to put these functions in an addin?

Does any one know of a guide to doing this?

TIA


-----Original Message-----
=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?'


.

Just open a new workbook, move the macros to that workbook. Then save that
workbook as an addin, it is the last file type in the list. Then goto
ToolsAddin and browse for that newly saved file to install it. Tick the
selection, and you are away.

--

HTH

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

"Edgar" wrote in message
...
How easy is it to put these functions in an addin?

Does any one know of a guide to doing this?

TIA


-----Original Message-----
=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?'


.