How to ...
This topic describes how to use various features of LockXLS.
General Questions:
Deployment Wizard questions:
Questions about LockXLS activation:
Advanced Questions:
LockXLS Runtime Menu:
Miscellaneous questions:
- How to start with LockXLS.
- How to change display language in LockXLS.
- How to install new version of the LockXLS.
- Where can I find Sample Projects for LockXLS?
- How to distribute my files to customer's PC.
- Upgrade your software to new version.
- How to avoid installing LockXLS Runtime on customer's PC.
- List of methods of the LockXLS Runtime Object available in VBA macro.
- Access LockXLS Runtime object from external application.
- Open locked file using ODBC driver.
- Can I protect XLA(XLAM) file using LockXLS.
- 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.
- Allow to open workbook not more then N times.
- How to 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
- Using 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
- Text in my RTF message appears truncated
- 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
- Enable\Disable printing from VBA macro
- Export cells with a specific background to external file
-
Access to registration information from VBA macro.
You can use this technique to limit features during trial period, display working period, Computer Code, etc.
- Use your own Help file in locked workbook.
- How to determine is opened workbook locked?
- Get path to folder, where your locked application file is located.
- Setup Package creates multiple entries in the Control Panel.
-
Create unlocked workbook from VBA macro in locked file.
For example: your locked file creates new workbook and copies some data into it. By default LockXLS locks this new file with same settings as source workbook. But if needed you can unlock it and make formulae available to customer.
- I have several linked workbooks. Can I lock them with LockXLS to the application?
You can lock linked workbooks in same way as usual workbooks. Please check Samples topic to find an example of the project with locked linked workbooks.
- Combine Hardware Based Activation Code protection option with Trial Period protection.
-
How to hide LockXLS messages about expired trial period?
You should use a Hide LockXLS Runtime messages option.
-
Excel 2000 does not have an option to block selection of locked cells on the protected sheet.
This issue can be solved by using EnableSelection property on the protected sheet. Go to the Visual Basic Editor and for this sheet set this option to "1 - xlUnlockedCells".