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?