what is the vba (not using protect sheet) to prevent copy paste, drag and right click to one column only - say, column A.
or maybe a set of columns range A:E
many thanks
what is the vba (not using protect sheet) to prevent copy paste, drag and right click to one column only - say, column A.
or maybe a set of columns range A:E
many thanks
this will do, go to your worksheet events:
Please Login or Register to view this content.
thank you for your reply.
the codes you posted prevents copy paste to the whole worksheet.
what I am requesting is to prevent only on a certain column or range of columns - not the whole worksheet.
many thanks..
oops, my bad. maybe this:
Please Login or Register to view this content.
thank you for the reply.
the code is preventing data entry.
it should allow input of data but not copy paste.
sorry I might have missed it in the OP.
many thanks..
sorry this is better:
Please Login or Register to view this content.
splendid!!!
it worked very nicely.
many many thanks..
I think this should also prevent DRAG.
Please Login or Register to view this content.
Last edited by LFKim2018; 10-15-2018 at 04:17 AM.
thank you very very much...
sorry - spoke too soon.
the code I inserted - it is preventing the DRAG beyond the 4th column - as a matter of fact - to the whole worksheet!
how can we control this for up to the 4th column (D) only?
again - many thanks..
Last edited by LFKim2018; 10-15-2018 at 04:25 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks