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)