Disable Copy and Paste for Specific Range, VBA

[bepedicino]

Looking for VBA code that will disable copying and pasting "only" for a specific range in Excel?

 

[Caleeco]

Hello,

There may be a VBA solution to do this, however, if you want to prevent Copying of data; have you considered locking cells? That way cells you wish not be copied are not selectable by the user.

Lock or unlock specific areas of a protected worksheet - Microsoft Support

How to lock cells in Excel to protect your data. You can also unlock a range of cells and grant permissions to others to edit.

support.office.com

Caleeco

 

[bepedicino]

I have considered that. I need users to be able to enter data manually, just not paste. The reason being that my data validation will not work when the end user paste data into the cell.

 

[lnieto]

I've found this solution: Excel VBA How to detect if something was pasted in a Worksheet

 

[bepedicino]

Thank you!