Protect only several formulas on a sheet
If you need to protect only several formulas on a sheet, and leave other ones available for modification, you should do the following:
Select formulas, which should be available to customer, mark them as unlocked (Excel | Format Cells ... | Protection | Locked option is unchecked).
Select cells, where customer can enter his own formula, mark them as unlocked as in the previous step.
Protect this worksheet with a password in Excel.
In LockXLS project check option
Additional Options | Formulas | Do not protect unlocked cells on the protected worksheet
Rebuild your project.
Now in the locked file you can select this sheet and enter/edit formulas.
When this option is selected:
Worksheet is protected - LockXLS hides only formulas in the locked cells. If cells is not locked - formula is visible. Also
he can enter and edit his own formula in unlocked cell.
Worksheet is not protected - LockXLS works as usual - every formula is hidden. If customer enters his own formula - he will not
be able to see and edit it.