break the links before you send the file.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Raina wrote:


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 is
asked to update the links (due to UDF's). If no is selected, all the
cells having UDF returned values shows error. If yes is selected, they
dont have the linked file containing UDFs.
I do not want to add those functions on the file. I have it in my
personnal.xls file.

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

Regards,
Raina