Preventing copy/paste into protected sheet

I'm using Excel 2013 and have a protected worksheet that restricts number of characters, char-type, upper/lower etc. I'd like to know how to prevent people from doing copy & paste into the form because they are bypassing the verification restrictions by doing so and it allows more than the restricted 15 characters into the field.

Brian

Could this work for you?

Please Login or Register  to view this content.

Originally Posted by bgane

I have data verification in each CELL that prevents more than 15 characters when you type it in but when they copy/paste into the form, it allows more than 15. I'd like to stop them from doing a copy/past altogether if possible. If not then how would I apply your subroutine for more than one column of data (i.e. 40 cells).

When you refer to the form I am expecting you to have a userform. Is this correct or is this a worksheet with cells that you have made to look like a form?

Could you attach a copy and I'll have a look?

Here, see attached workbook (sample I did for another forum sometime ago).
Change target column/range as needed.

Based on concept found in link below.

https://www.mrexcel.com/forum/excel-...worksheet.html

If you are using Cell as the 'Form' then apply this code to that worksheet and change Range("A1") to whatever you 'form' range is

Please Login or Register  to view this content.

This is a worksheet that looks like a form. There is currently no VB included, only data verification code for the unlocked cells that allow user input. I've attached the unprotected worksheet.

Brian

Originally Posted by CK76

Here, see attached workbook (sample I did for another forum sometime ago).
Change target column/range as needed.

Based on concept found in link below.

https://www.mrexcel.com/forum/excel-...worksheet.html

it doesn't work
I can copy cell into A column
or use in any cell of A column something like: =D1

How does this work/look?

@Sandy666
Hmm? I tested and worked fine on my end.

Note that this code should be used in conjunction with Data Validation.

So, =D1 will not be allowed if it's not allowed by Data Validation.
Code just disables Cut/Copy and paste into range.

0.JPG

Originally Posted by CK76

@Sandy666
Hmm? I tested and worked fine on my end.

Note that this code should be used in conjunction with Data Validation.

So, =D1 will not be allowed if it's not allowed by Data Validation.
Code just disables Cut/Copy and paste into range.

Attachment 511261

This file isn't using a list/dropdown

@PFDave
I dodn't touch your vba code, but....

That works, thank you very much!!

Appreciated.
Brian

Weird, same for me :/

Hows this?

Originally Posted by bgane

That works, thank you very much!!

Appreciated.
Brian

You're welcome Brian.

If that takes care of this thread please mark as solved, and add any reputation that you see fit

@PFDave
If you wish

Originally Posted by sandy666

@PFDave
If you wish

????

The first attached file didn't open, now this one opens and still works? You'd stumped me sandy