How to Use every workbook User defined function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mvenkatesan45@gmail.com - 07 Aug 2007 16:45 GMT

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

Reply to this Message

Peo Sjoblom - 07 Aug 2007 16:59 GMT

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

file>save as> *.xla

Signature

Regards,

Peo Sjoblom

> Hi,
> All of ur guidance is very useful me. Thanks a lot.
[quoted text clipped - 7 lines]
>
> Venky

Reply to this Message

Gord Dibben - 07 Aug 2007 17:06 GMT

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

>Hi,
>All of ur guidance is very useful me. Thanks a lot.
[quoted text clipped - 7 lines]
>
>Venky

Reply to this Message

Rate this thread: