LockXLS On-line Help Library

Getting Started
Using LockXLS
How to ...
General Questions
Questions about LockXLS activation
Advanced Questions
LockXLS Runtime Menu
About LockXLS

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.