Hi all,
I am using the colour functions of Chip
( http://www.cpearson.com/excel/colors.htm )

It works fine and is of great help. But I faced a small problem.
Whenever I mail my file with those functions, the mail receipant i
asked to update the links (due to UDF's). If no is selected, all th
cells having UDF returned values shows error. If yes is selected, the
dont have the linked file containing UDFs.
I do not want to add those functions on the file. I have it in m
personnal.xls file.

Is there a way, by which, if the UDF is not found by Excel it wil
convert the function returned values to plain values ( just like past
special | values) leaving other cell formulas and referances as it is?

Regards,
Rain

--
Rain
-----------------------------------------------------------------------
Raina's Profile: http://www.excelforum.com/member.php...fo&userid=1550
View this thread: http://www.excelforum.com/showthread.php?threadid=27272