Trigger Worksheet Change by copy and paste

The following code seems to work fine if the user selects a value from the drop down cell in column T, but if that user then copies and pastes his selection into subsequent cells, it appears that the event is not trigger so the data validation does not get added to column S as it should. Could anyone provide some assistance to this? I am sure my code is a little redundant (still trying to learn all this). This code is on the actual sheet tab, just in case you didn't already know that.

Please Login or Register  to view this content.

but if that user then copies and pastes his selection into subsequent cells

Please Login or Register  to view this content.

does different stuff to if it is 1.

I also note you use different passwords for protecting and un-protecting the worksheet.


Regards, TMS

Difficult to know without the workbook, and an understanding of the exact steps you follow. I can set up what I think it looks like and I can change a value in column T and get the DV in column S. If I delete a whole bunch of cells in column T it will clear the DV and lock the cells.

What I'm saying is that I don't really know how to reproduce the problem. I don't know what cells have what values and, if you get the DV in a cell, which cells are you trying to copy it to?

Regards, TMS