need new workbook copy protection
We need a higher level of workbook and worksheet protection perhaps set to the user ids own computer and allowed devices. This way excel documents with hidden formulas, code etc can be shared to people outside that network without worrying about special details (secrets) getting into the wrong hands. Currently workbook passwords can be unlocked with code, etc.
There are two ways to get strong encryption and protection of Excel files:
1. DRM (Click on File > Info > Protect Workbook > Restrict Access) can be used to only allow certain users to access a file.
2. Workbook Protection (Click on File > Info > Protect Workbook > Encrypt with Password) can be used to encrypt a file. When set, only users with the password can open the file to see the contents.
the password protection is so weak that macros are out there to remove it. Please read my post before replying