I use the following code to prevent students from copying from another Excel file and pasting into their own.
Now I wanted to allow Copy/Paste in selected sheets. So I tried the following code in the CodeModule of ThisWorkBook.
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
Bookmarks