ListDataValidation Property [Excel 2003 VBA Language Reference]
A Boolean value that is True if data validation is enabled in a list. Read/write Boolean.
expression Required. An expression that returns one of the objects in the Applies To list.
Data validation for a list can also be turned on or off by in the user interface by selecting or clearing the List data validation error check box on the Error Checking tab of the Options dialog box.
Sub PrintListValidationOnOrOff() Debug.Print Application.ErrorCheckingOptions.ListDataValidation End Sub