Additional Options.
Allow to modify unlocked cells on protected worksheets - You can give your customer ability to enter his own formulas and edit them. Custom formula could be entered only into unlocked cell on protected sheet. More ...
Allow to unprotect sheets in locked workbook - LockXLS blocks Protect/Unprotect Sheet, Protect/Unprotect Workbook dialogs and
does not allow the end customer to unprotect sheet or workbook structure. If this option is selected - your customer can enter password to unprotect
sheet/workbook and then protect is again.
Allow to unhide sheets in locked workbook - LockXLS does not allow to make hidden sheets visible. But if you need to allow this in your workbook - turn this option ON. More ...
Do not hide formulas on protected sheets - If your worksheet is protected (we mean Excel's protection with a password), locked formulas
is unavailable for user. This option makes locked formulas visible to user. But user can not modify them - Excel does not allow to modify locked cells on
a protected sheet.
Leave VBA Code available to modification - VBA Code is not protected. You customer can see and modify it.
Leave formulae available to modification - All formulae are available for modification
and copiing.
Disable printing in this workbook - do not allow the end user to print this workbook. Print and Print Preview operations are blocked. You can modify this behaviour from VBA macro and enable\disable printing in locked workbook. You can find more information in the How to topic.
Users, who can print this workbook - if you've disabled printing in this workbook, you can specify list of Windows users, who can print it. This feature should be used if you know user names of your customers.
Allow to save modified data to external file - LockXLS Runtime gives ability to save/load cell values to/from text file. You can use it to move data from old version of your file to the newer one.
Save modified data in protected format - Items in LockXLS menu save modified data and cell values into text files. When this option is checked, text files will be saved in protected format and could not be read and by users.
More about saving modified data ...
Check for new versions of LockXLS Runtime on customer's PC - If this option is checked, LockXLS Runtime checks our website for new version. When new version of LockXLS Runtime is published on our website, your customer will be notified. He has several options - download new version, remind later or stop checking for new versions. More ...
Allow to open workbook if activation failed - If customer's activation expired, or he doesn't have password to open workbook, this option allows to open workbook with limited functionality. More ...
Hide messages from LockXLS Runtime - this option hides all messages shown by LockXLS Runtime for EULA,Reminder,Succeeded/Failed activation. If you are using macro to open locked workbook, you can specify your own interface for an expired working period. This option hides all LockXLS messages and you can catch the error in VBA code and show your own form.