An Excel template has been created and a Date validation has been applied on a column of cells where the Error alert gets displayed on entering invalid data. This has been done by selecting "Show error alert after invalid data is entered" checkbox in the Error Alert tab of the Data validation dialog box.
But if invalid data is Copied into the cell the alert is not fired. Is there any way to display an alert even if data is copied and not entered? Can copy-paste be disabled in EXCEL?

Thanks,
sap