Protected Sheets and Workbooks

[c0087]

I just got done creating a couple of password protected files (.xlsm).
Works fine when using Excel, but I can open them with LibreCalc and
all the worksheets can be unlocked/unhidden without any password protection.

Any solutions for this?

 

[mikerickson]

No
Excel protection is not for security (i.e. keeping secrets) it is for protection against clumsy fingered users.

 

[c0087]

Excel protection is not for security (i.e. keeping secrets) it is for protection against clumsy fingered users.

Not sure that's true at all. Why not just have the "lock" option then instead of hiding formulas, passwords, etc.

 

[mikerickson]

You have walked into one way to remove Excel sheet and workbook protection. Only one of the several ways.

No matter what its intended uses, the protection provided by Excel is, in reality, no good for keeping secrets.