I use the following code to prevent students from copying from another Excel file and pasting into their own.

Please Login or Register  to view this content.
Now I wanted to allow Copy/Paste in selected sheets. So I tried the following code in the CodeModule of ThisWorkBook.
Please Login or Register  to view this content.
But it does not work. This allows copy/paste in all sheets. If I keep the original code block along with new code, copy/paste is blocked in all sheets, the new code does not have any effect.

I tried similar code in Worksheet code module as well, and that did not work also. I can't figure out what I am doing wrong. Any help is much appreciated.

Dileep