Hi All,

I'm looking to protect a document from being copied as the data that is has within it is sensitive. I can hide sheets, password protect and have removed the "Save As" facility so covered off a few points. I am though conscious that the file could still be removed using "Copy" and "Paste" so want to only allow it to be used if it is within the desired location on the PC.

I am a complete novice to VBA but have found a link that was posted some years ago which seems to cover what I want but I have tried to install the code but its not working. I may be doing everything OK but the instructions need to be a little more "idiots guide" for me to understand. Would anybody know how to get it to work or another option please? The link is as below;

https://uk.answers.yahoo.com/questio...3214412AAxtRD9

Your help is greatly appreciated.