Removing a user's ability to paste

[jonvanwyk]

I have several worksheets in my workbook in which I do not want a user to have the ability to copy/paste, or more importantly paste. If they cannot paste, then the copy function is moot (and vice versa), so really I just need to remove their ability to do one or the other. Is there VBA that can be inserted into the worksheet module to accomplish this?

Update: Or just remove their ability to "right-click", and disable "Ctrl-C". The ribbon is otherwise gone, so these two things might also accomplish what I am setting out to do.

[jonvanwyk]

Nevermind. I figured it out, and the solution is listed below.

Just use this code in the "ThisWorkbook" module...

Please Login or Register  to view this content.

...and then this code in a standard module.

Please Login or Register  to view this content.