Forum Discussion
Disallow Paste within a particular range without unloading the Paste Stack
Hi Experts, I wish to disallow paste in Named Ranges "ListOnly1" and "ListOnly2" on Sheet 1 "ListOnly3" and "ListOnly4" on Sheet 2 All the above ranges contain Validation Lists and user might ...
I am not sure how protecting the sheet will disallow paste on the unprotected cells. We cannot protect cells, if we wish to enter or select a validation list value in those cells.
The purpose is to disallow paste on the protected cells. You protect the cells that are the source of the validation list. You unprotect the cells that holds the data validation (where presumably someone is selecting from a drop-down, or entering a value).