user-defined function...

[Stanislav Michailov]

Hi,

I would like to ask how to make global user-defined function written in some
file
so that it would be available for use in other excel files as well?

Thanks,
Stanislav Michailov

 

[Gilles Desjardins]

Place your VBA code in the "personal.xls" file. Windows, unhide, personal
then alt-f11 to enter your code.

HTH

Gilles

 

[Frank Kabel]

Hi
put the UDF in your Personal.xls file. Have a look at
http://www.mvps.org/dmcritchie/excel/getstarted.htm
for instructions