Patrick,
I followed your suggestion and saved the new workbook as an XLA in
....\Documents and Settings\....\Excel\XLSTART\UDF.XLA, where it opens up
automatically just as PERSONAL.XLS does.

But the name of the UDF that I originally wrote in PERSONAL and transferred
to the new .XLA is now not recognized.

PS I am using Excel 2003 under Windows XP SP2 - if that is relevant.

"Patrick Molloy" wrote:

put them in a module in a new workbook then save as an XLA ( Excel Add-In)
save this in the default STARTUP location so that it loads whenever excel
starts.


"Hershmab" wrote:

I want to create UDFs that I can use in any of my applications just like
ordinary Excel worksheet functions. I have found that if I place the
module(s) in Personal.xls I have to prefix the function name by that workbook
name.

Is there somewhere else to put them so that I can use the bare function name
in any formulae?