LockXLS On-line Help Library

Welcome
Getting Started
Using LockXLS
How to ...
General Questions
Questions about LockXLS activation
Advanced Questions
LockXLS Runtime Menu
Samples
About LockXLS
Purchase
Contact
Make formulas visible to customer but unavailable for modification

Make formulas visible to customer but unavailable for modification.

If you use Excel's protection ( Tools | Protection | Protect Sheet, or Review | Protect Sheet in Excel 2007 ), LockXLS Runtime hides cells with formulas. Option Protection Options | Additional Options | Do not hide formulas on protected sheets allows to make locked formulas visible to customer. But they are unavailable for modification, because Excel does not allow to modify locked cells.