Have an explore of 
 Application.ErrorCheckingOptions.ListDataValidation = False
It applies to the entire Excel Application, so if you want to preserve it's TRUE status for elsewhere you could put that line in the Worksheet_Activate() event and set it back to TRUE in the sheet's Worksheet_Deactivate() event. (I still can't test if this will work since I can't get such an error to appear here.)