Don't believe the error-checking feature was available for 2000 version.

Never used 2000 but I am fairly positive EC was first introduced with 2002
version.

Definitly is available for 2002 and 2003.


Gord Dibben MS Excel MVP



On Fri, 11 Aug 2006 08:33:35 -0400, brianbishop
wrote:


Hi All

Wrote VBA code to disable the error-checking options (in Excel 2003);

With Application.ErrorCheckingOptions
BackgroundChecking = False
EvaluateToError = False
TextDate = False
NumberAsText = False
InconsistentFormula = False
OmittedCells = False
UnlockedFormulaCells = False
EmptyCellReferences = False
ListDataValidation = False
End With

Works fine, BUT

Sent to a colleague, using a different verison of excel, gives an
error.
Do the error checking options differ in 2002 and 2000? If so, what are
the options available in these versions?? I tried long and hard to find
the answer, I think 2002 has the same options, but cannot find anything
for 2000

Any help will be appreciated