Hello - I am currently evaluating the trial version of XLS Padlock before I officially buy. I have a few questions, so I’ll post a couple threads.
I have a workbook of about 12ish tabs that contain a lot of formulas. I’d like to protect the formulas, but I also want to limit the ability of my end-users to change any data to protect sheet integrity. Is there a benefit to using both formula with sheet and/or workbook protection from the native worksheet?
Thanks!
We don’t recommend protecting all cells: this would slow down execution of Excel.
The goal is that if someone manages to remove the protection, protected cells will stop working and thus the workbook becomes useless. So basically, you should choose some cells to protect with XLS Padlock’s own formula protection, and use the native Excel protection (hidden attribute) for all other remaining ones.
There are known tricks to deprotect hidden cells through password cracking, but this requires VBA. If you block access to VBA editor with XLS Padlock, you should be OK.