XLS Padlock lets you keep your formulas secret.
Excel lets you hide formulas thanks to a password:
XLS Padlock lets you go further: you can protect any formula in any worksheet by replacing it with a built-in function only available when your application runs.
In the compiled project, formulas will be replaced in the Formula Bar by anonymous functions like =PLEvalForm(0), =PLEvalForm(1), =PLEvalForm(2)....
But calculations will still work.
This increases the security of your workbook: protected cells can only work properly if the application runs.
To protect a formula, you just have to right click on the cell where the formula is, and select “Protect this cell with XLS Padlock” in the mouse context menu.
When compiling your workbook, XLS Padlock will replace all listed cells with generic PLEvalForm(N) function calls. Your cells remain functional but end users can’t discover formulas behind.
You can have an overview of all the protected cells by clicking “Protect Formulas” in XLS Padlock tab or menu: