Disable Copy and Paste for Specific Range, VBA

bepedicino

Board Regular
Joined
Sep 29, 2014
Messages
70
Looking for VBA code that will disable copying and pasting "only" for a specific range in Excel?
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Caleeco

Well-known Member
Joined
Jan 9, 2016
Messages
935
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.


Caleeco
 

bepedicino

Board Regular
Joined
Sep 29, 2014
Messages
70
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,253
Messages
5,467,563
Members
406,543
Latest member
semoredhawk

This Week's Hot Topics

Top