Custom Function

  • Thread starter Thread starter Edgar
  • Start date Start date
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?'
 
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)
 
You need to qualify the macro name with the workbook name (unless the
file is an add-in). E.g.,

=Personal.xls!MyFunction
 
=personal.xls!Myfunctionname(arg1, arg2)

Or put them in an Addin and load the addin. Then you won't need the
filename.
 
How easy is it to put these functions in an addin?

Does any one know of a guide to doing this?

TIA
 
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)
 
Back
Top