Hi,
I've inherited an Excel workbook that has a large number of dropdowns used
for data validation. The sheet is protected to prevent users from being able
to paste values into the workbook. I'd like to allow users to perform a
paste operation, and cause the validation associated with each of the
drop-down lists to fire so that the paste can be prevented if the data input
is invalid. This needs to work on Excel 97 and higher.
Is this possible?