Hi all,
I have a problem. We have created some common UDF Excel functions and
put them into an XLA Adds-in (eg COMMON.XLA) file and distributed them
among several users.
Users then store these COMMON.XLA files wherever they want on their
hard drives.

Problem:

If a user uses one of these UDFs in their own Excel sheet, everything
works fine. - Eg: A1 cell contains: "=MYFUNC()"
However when the Excel sheet is opened by an other user, where the
physical location of this COMMON.XLA is different, then Excel will not
find MYFUNC() function, COMMON.XLA is open (and hidden), because what
the user sees is something like this:
"=+'C:\Program files\My functions\[COMMON.XLA]'!MYFUNC()"
and A1 cell contains a #REF error message as the (otherwise open)
COMMON.XLA is in a different folder.

How can I tell Excel to ignore the path for UDFs?

Thanks,
Hege


--
hege
------------------------------------------------------------------------
hege's Profile: http://www.excelforum.com/member.php...o&userid=17533
View this thread: http://www.excelforum.com/showthread...hreadid=532910