Saving user defined functions

  • Thread starter Thread starter Lawdog
  • Start date Start date
Either in your Personal.Macro Workbook(Personal.xls)

Or in an Add-in which you create by opening a new file, inserting a general
module for your UDF's ans saving as File Type>Excel Add-in(*.xla)

I prefer the add-in route since you then don't have the precede the function
name with the workbook name.

i.e. with Personal.xls a UDF must be entered in a cell as

=Personal.xls!UDFName(cellref,args)

With an add-in =UDFName(cellref,args) will suffice.

I also prefer the add-in so's I can share the add-in with others thus
preserving their own Personal.xls


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access ConcatRelated() Function Not Working 0
VBA CODE HELP! 0
How to Convert MBOX to PST Online? 3
User defined function 4
Help defining a user-defined function 7
Set non-continuous PrintArea via Function / Name 0
Excel EXCEL - Set non-continuous PrintArea via Function / Name 0
Excel Excel VBA (Saving as A CSV) 1

Back
Top