Thanks Boni. I may be able to use that approach.


"BoniM" wrote in message
...
Just FYI - may not be applicable, but if you are using sheet protection
and
hide the formulas, they are not displayed.

"JoeM" wrote:

Hello,

I have created a spreadsheet that has numerous cells that have a little
green triangle in the upper left corner, indicating that Excel thinks
there
may be an error. In this case there is no error. Everything is
functioning
the way i want it to.

I know how to tell Excel to ignore the error, and I could even modify the
error checking options under "Excel Options." Well enough.

But I am going to be emailing this spreadsheet to other people, and I
would
like to make sure that the little green triangles do not appear when they
open the spreadsheet. I am using Excel 2007 in Compatibility Mode
(saving
as .xls), but I have no idea what version(s) of Excel the other people
may
be using.

I would think that if Error Checking rules are workbook-specific that I
could just change them, save the workbook, and I'd be all set. So my
question is: are Error Checking rules workbook-specific? And, if not,
is
there anything else I can do to accomplish my objective of preventing
other
users from seeing the little green triangles?

Thanks,
Joe