Macro - Insert code to ThisWorkbook

[Studynot]

Hi all,

I'm having an issue and I don't know how to start. There is a workbook that our company sends out to outside parties and we would like to prevent those people from cutting/copy/paste. This workbook is a data dump from our ERP system that then runs through a fairly complex macro to do all the necessary formatting and get the information into a readable format.

I would like to insert vba code into the macro that is already run on the raw data that will do the following:

1. Insert a Module into the "ThisWorkbook" Class for the workbook it's running on
2. Have that Module populate with a Private Sub that activates on opening the workbook and deactivates if you switch to a different workbook or close this workbook
3. The Private Sub would disable the cut/copy/paste functionality related to Keyboard shortcuts, menu bar, & right click context menus

I have done some google searches that come up with code to insert a module, but everytime I try and execute those it pops up with the "Choose a Macro to run" window. If I choose one it simply runs that macro's code...

Thanks in advance for help on this!!

Let me know if there is any clarification required!