Select from a Data Validation Menu whilst preventing Pasting

[HangMan]

I found this code on the forum which prevents the user from pasting into a cell which contains a Data Validation List:

Please Login or Register  to view this content.

The problem I have is that with this enabled, whilst it successfully prevents the user from pasting into the cell, it also prevents the user from selecting an option from the drop down list (created using Data Validation and the List Option). Is there any way to adapt the code to achieve the same thing but still allow the user to select an option from the data validation drop down list?

Many thanks

[JBeaucaire]

Maybe this:

Please Login or Register  to view this content.

[HangMan]

Hi JBeaucaire,

That does the trick, many thanks. If I want to keep the 'message' when they attempt to paste anything, how would I do that? I tried:

Please Login or Register  to view this content.

but that activates the message when the cell is clikced on, rather than when the user attempts to paste to the cell itself. Apologies, my VBA is very limited.

Many thanks

[JBeaucaire]

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[HangMan]

Hi JBeaucaire,

That does the trick...

Many thanks for your help, much appreciated.

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.