How to Use every workbook User defined function

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
 
P

Peo Sjoblom

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

file>save as> *.xla
 
G

Gord Dibben

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
 
Top