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 overwrite using copy-paste.
Is there any VBA or Non-VBA solution to this issue.
Regards
Kanwaljit
3 Replies
As a general rule, if you want to prevent editing of a cell or a group of cells, you should lock the worksheet.
First, select all the cells you want the user to be able to edit. Then right-click and select "Format Cells". Go to the protection tab and de-select "Locked".
After you password protect the worksheet, those cells that have Locked deselected can be edited as normal. Those which are still Locked will not be editable.
To lock the worksheet, right-click the sheet tab and select "Protect sheet".
Decide which actions users should be able to take on locked cells by selecting or deselecting the items in the list.
For more information, please read this
- 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).
