Option is to store all UDF within the workbook. But I guess you're after
storing them externally.

You could create a VBA reference to the XLA. This works alright for me.

To truly get rid of the qualifier you create an XLL.

Excel XP + has an Automation Add-In which is nice, but not as nice as XLL
(in my opinion). Before Recalc you get to see formulas qualified with the
ProgID.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Basil" wrote in message
...
Hiya,

I created a user defined function in the module of personal.xls. Thing is
I need to call the function like this to get it to work:
=personal.xls!MyFunction(A1).

Where should I put it so that I can simply call =MyFunction(A1) ?

All the xla's seem protected.

Baz