Colour functions of Chip - small problem

R

Raina

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chip Pearson UDF returns #VALUE! error please help, just cannotfigure out why? 4
Can UDF return a customized hyperlink? 3
function to re-calculate when cell format (colour) changes 1
Formatting cell poulated by User Defined Function 6
function with more functionality then typical UDFs? 10
PlaySound error (Chip Pearson site) 2
Colour functions on Chip's page 3
Interior Cell Colour - Conditional Formatting 3

Top