Restrict Copy/Paste

Hi, Is there a way to prevent copy/pasting from one workbook into another, but allow copy/pasting within the workbook? This will be useful to check cheating by my students.

Thanks, Dileep

Hi there,

The Cheap 'n' Cheerful way to do this is to use the following code in the ThisWorkbook module, but it won't stop students from copying entire worksheets to another workbook:

Please Login or Register  to view this content.

Probably not as foolproof as you had hoped for, but it's getting late at this end!

Hope this helps.

Regards,

Greg M

Thank you Greg. This would prevent all copy/paste isn't? I would like the students to be able to copy/paste within the workbook they are working on, but prevented from doing so from some other workbook.

Dileep

Hi again,

Copy/Paste within the workbook itself is allowed, but the contents of the ClipBoard are cleared as soon as another workbook is activated.

Regards,

Greg M

Thank you Greg, worked perfectly, initially I put the code in a module and it didn't do anything. Then I put it in the Worksheet and it worked. I appreciate your help.

Dileep

Hi again Dileep,

Many thanks for your feedback and also for the Reputation increase - much appreciated!

You're welcome - glad I was able to help.

Regarding:

Then I put it in the Worksheet and it worked.

The code should be put in the VBA CodeModule for ThisWorkbook rather than in the CodeModule for a Worksheet.


Best regards,

Greg M

Hio Greg, I have a follow up question. I wanted to allow Copy/Paste to one or two sheets. So I tried the following code in the CodeModule of ThisWorkBook.

HTML Code: 

But it does not work. I put a MsgBox to see whether code is executed and it does. But the "Application.CutCopyMode = False" seems to have no effect. Would you please help?

Thank you, Dileep