• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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


Excel Ninja
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.