Error Checking Options - 2000-2003

[brianbishop]

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

[Gord Dibben]

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
<[email protected]> 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