How to prevent user from pasting data in a range, protected range won’t work

[ThrottleWorks]

Hi,
I have a worksheet. In range E11:E30 I have validation as Yes, No.
User need to select each cell as either Yes or No.
User should not simply copy paste values in these cells. How can I prevent this.
Motive is user should select Yes or No in each cell based on their understanding.
Protected sheet won’t work, not able to understand how I can stop user from pasting data in the range.
Can anyone please help me in this.

 

[Marc L]

Hi, just lock the cells then protect the worksheet …​

​

 

[ThrottleWorks]

Hi @Marc L thanks a lot for the help. Have a nice day ahead.