ExcelBanter - How to use User-defined-functions in other workbooks?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to use User-defined-functions in other workbooks? (https://www.excelbanter.com/excel-programming/309978-how-use-user-defined-functions-other-workbooks.html)

JohnDing

How to use User-defined-functions in other workbooks?

How to use User-defined-functions in other workbooks other
than saved "xla" files.

Tom Ogilvy

How to use User-defined-functions in other workbooks?

=Personal.xls!Myfunction(arg1,arg2)
the workbook with the UDF must be open.

Or copy the UDF to the workbook where you want to use it.

--
Regards,
Tom Ogilvy

"JohnDing" wrote in message
...
How to use User-defined-functions in other workbooks other
than saved "xla" files.

Ron Rosenfeld

How to use User-defined-functions in other workbooks?

On Wed, 15 Sep 2004 01:39:43 -0700, "JohnDing"
wrote:

How to use User-defined-functions in other workbooks other
than saved "xla" files.

Put it in your personal.xls file

--ron

All times are GMT +1. The time now is 03:14 AM.