Hello -

I set up a spreadsheet with drop-down menus for some of the cells. The
user can only select values from that list and an error message pops up
when something is typed it that is not in the list (via Data Validation
> Error Alert).

So this works all fine ... except if the user copies and pastes a cell
with a different drop-down menu into a cell overwriting the existing
validation.

I cannot totally lock the worksheet and if I lock the cells with the
drop-down menus nothing can be changed. So how can I prevent this from
happening? Is there a way to block all copy/paste operations that are
copying the validation? I know that with the Paste Special I can have
cells copied without the validation.

Thanks for any comments!
Joe