Improve protection of your workbooks > Protect your formulas with XLS Padlock’s formula protection |
In additional to Excel’s cell protection, we strongly recommend you secure important formulas of your workbook with XLS Padlock’s own formula protection.
After protection with XLS Padlock, all formulas do not appear anymore while remaining functional. Instead a cryptic call PLEvalFormD is shown:
The goal is that if someone manages to recover the workbook from the EXE shell as explained in Improve protection of your workbooks, protected formulas will stop working. Thus, the workbook should become useless, because its formulas protected by XLS Padlock are no more in the workbook file!
XLS Padlock lets you decide which cells you want to protect (it’s possible to select several cells to protect in one time).
Learn more about formula protection and how to protect your formulas efficiently
Disable common Excel add-ins | Real VBA code protection with VBA compiler