 |
Welcome |
 |
Getting Started |
|
Using LockXLS |
 |
How to ... |
|
General Questions |
|
How to start with LockXLS |
|
How to change display language in LockXLS |
|
How to get Sample Projects |
|
How to install new version of the LockXLS |
|
LockXLS Runtime Object members |
|
Access LockXLS Runtime Object from external application |
|
Open locked file using ODBC driver |
|
How does the Hardware Based Activation Code work? |
|
I need to allow customer to evaluate my product 30 days, and then he will purchase a license, which should be renewed after 90 days. |
|
Can I protect XLA(XLAM) file using LockXLS |
|
Allow to open workbook not more then N times |
|
Change captions and labels shown to my customer during activation |
|
Protect only several formulas on a sheet |
|
Make formulas visible to customer but unavailable for modification |
|
Use LockXLS application from command line |
|
Create your own folder structure for output files |
|
Allow to unhide sheets in locked file |
|
Use hyperlinks in the custom message |
|
Create Setup Package for your Product |
|
Text in my RTF message appears truncated |
|
Questions about LockXLS activation |
|
Advanced Questions |
|
Text which begins from '=' character is not shown in the locked workbook |
|
Open protected file without asking password |
|
Protect Charts and Objects from modification |
|
Make my spreadsheet working without activation on specific PCs |
|
Save workbook as usual Excel workbook without protection |
|
Make data on hidden sheets available to my external application |
|
Allow to unprotect sheets from external appliation |
|
Generate Activation Codes online |
|
EnableDisable printing from VBA macro |
|
Export cells with a specific background to external file |
|
Access to registration information from VBA macro |
|
How to determine is opened workbook locked? |
|
Get path to application file |
|
Create unlocked workbook from VBA macro in locked file |
|
Setup Package creates multiple entries in the Control Panel |
|
Combine Hardware Based Activation Code protection option with Trial Period protection |
|
LockXLS Runtime Menu |
|
Samples |
|
About LockXLS |
|
Purchase |
|
Contact |
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.