Hi David,

You should endeavour to avoid changing other people's Personal.xls files.

You could send the UDF as a text email with instructions on adding the
function to the user's Personal.xls.

You may also wish to visit Jan Karel Pieterse's site:

http://www.jkp-ads.com/Articles/DistributeMacro02.htm



---
Regards,
Norman



"David" wrote in message
...
Greetings,
I want to distribute a UDF to several users on different work stations.
i'm
looking for a very simple process from the users' point of view. I thought
maybe a good way of doing this would be to send them a file with a macro
that
writes the UDF to their personal.xls
If this possible, how would I proceed?
Is there a better way?
TIA
--
David