Custom Function

E

Edgar

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

Bob Phillips

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)
 
J

JE McGimpsey

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

=Personal.xls!MyFunction
 
T

Tom Ogilvy

=personal.xls!Myfunctionname(arg1, arg2)

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

Edgar

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

Does any one know of a guide to doing this?

TIA
 
B

Bob Phillips

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
Tools>Addin 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)
 
Top