Disable copy paste function without VBA code

[dhirajashet24]

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 either from same excel or from another excel sheet. How to protect or stop copy paste on drop down column but select from drop-down option enable and save the file. I tried using protect sheet function but then drop-down function cannot be selected and save. Also VBA coding is not allowed.

[#2]

@dhirajashet24 

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.

1. Select all cells with drop down list in the worksheet you need to protect. Click Find & Select > Data Validation under Home tab.
2. 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.
3. 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.

NikolinoDE

I know I don't know anything (Socrates)