Forum Discussion
Disable copy paste function without VBA code
Hello, need some guidance in Excel. We have standard Excel format in office and customer need to update the data in the same format however they overwrite the drop down list by copy pasting the data ...
How to protect or stop copy paste on drop down column but select from drop-down option enable and save the file, without VBA?
The following steps may help.
- Select all cells with drop down list in the worksheet you need to protect. Click Find & Select > Data Validation under Home tab.
- Right click on them and select Format Cells in the right-clicking menu. In the Format Cells popup, go to Protection tab and uncheck Locked box. Click OK.
- Go to Review tab and click Protect Sheet button. In the Protect Sheet popup, check Protect worksheet and contents of locked cells option and enter a password if needed. Click OK.
This way, you can protect your worksheet from copying or pasting but still allow users to select from drop-down options.
Hope I could help you with these information.
I know I don't know anything (Socrates)