bepedicino
Board Regular
- Joined
- Sep 29, 2014
- Messages
- 73
Looking for VBA code that will disable copying and pasting "only" for a specific range in Excel?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Disable Copy and Paste for Specific Range, VBA
- Thread starter bepedicino
- Start date
Excel Facts
How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Caleeco
Well-known Member
- Joined
- Jan 9, 2016
- Messages
- 980
- Office Version
- 2010
- Platform
- Windows
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.
support.office.com
Caleeco
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
Upvote
0
bepedicino
Board Regular
- Joined
- Sep 29, 2014
- Messages
- 73
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.
Upvote
0
I've found this solution: Excel VBA How to detect if something was pasted in a Worksheet
Upvote
0
