Disable all copy functions in excel

[ayoung]

Hello all. I have a task before me that requires that users are unable to copy any data from a workbook. I approached this like so: I created a template, with a macro, "disable copy" that grayed out the entire edit menu, which is fine, but you could still right click in the worksheet and copy from there. Is there any way to completely disable this ability? TIA

 

[Tom Urtis]

See this link for a recent thread about this topic. In the code where I posted is a BeforeRightClick event that answers your specific question.

http://www.mrexcel.com/board/viewtopic.php?topic=21912&forum=2