Excel File Protection through Macro?

[sirmixalot]

Hi guys,

Long story short - bullied at work by both coworkers, boss, and HR.

Would like your advice on ensuring the excel files I created are only able to be opened by me i.e. my physical presence. I also want my excel files to be hard to access when provided to someone else whether via email or dropped into a usb drive in front of them.

Any assistance is appreciated on this. Sorry if it seems fishy, it's the best I can do under the circumstances. Please refrain from giving me other advice as that would make it off-topic.

Thanks!

 

[RoryA]

Frankly, you can't do this with macros. The only vaguely secure protection you can put on a workbook is the password to open it, which encrypts the file, but even that can generally be decrypted using online services.

Also, if you created these macros at work, or using company resources, the intellectual property most likely belongs to them legally, so you wouldn't be doing yourself any favours trying to do this (even if I understand the sentiment).

 

[sirmixalot]

Also, if you created these macros at work, or using company resources, the intellectual property most likely belongs to them legally, so you wouldn't be doing yourself any favours trying to do this (even if I understand the sentiment).

Excellent Point there - not doing myself any favors
I will just make do that I can create good reports and hone my excel skills. Thank you very much!