How to Use every workbook User defined function

  • Thread starter Thread starter mvenkatesan45
  • Start date Start date
M

mvenkatesan45

Hi,
All of ur guidance is very useful me. Thanks a lot.

I have one User defined function in my book. Evry time I'll open this
book.
then open proces workbook. How to use on my book's function in active
workbook?

Thanks

Venky
 
Either refer to the workbook that has the function or save the UDF as an
add-in

file>save as> *.xla
 
I would copy the UDF to a new workbook and save as an add-in.

Load the add-in through Tools>Add-ins and have your UDF available for all open
workbooks.

If you have a personal.xls file you could stick the UDF in there.

Note: if in Personal.xls yuou must preface the UDF like such

=Personal.xls!MyFunc(doodah)

If in an add-in, no need for the the filename.

=MyFunc(doodah) is sufficient.


Gord Dibben MS Excel MVP
 
Back
Top