In this example we will create a file which has the most common features needed for distribution.
We will build our project based on a project from previous example.
Possible, your customer does not want to install LockXLS Runtime on his PC, or does not have rights for this,
or may be any third-party Add-Ins are prohibited in his company. We will distribute our file as application. It does not
require any additional files to be installed on customer's PC.
Select Example.xls node in the project tree, and then check Convert this Excel document to application. Also we assign
our own icon to this file. Path to .ico file should be selected in the Custom Icon edit box.
Our project has a Help file, called from VBA macro assigned to button. In Example.xls we've created a ShowHelpFile procedure and
attached it to button. Help file CustomHelp.chm was created using Html Help workshop, it is included into LockXLS setup package.
Select this file in the Custom Help file edit box.
Rebuild this project and open C:\LockXLS Sample Project folder. Now this folder contains Example_Locked.exe file. This file does not
require LockXLS Runtime Module. You can copy it to other PC and run - it will open protected document and ask you for a password.
Show Help File button in file shows CustomHelp.chm.
We need a unique activation code for each our customer to prevent unauthorized copying. On the Protections Options tab
select Protection Option Hardware Based Activation Code. This type of protection requires Product Code for your file.
Activation Code is created for a pair (Computer Code, Product Code), so your customer can have several products on his PC. You can enter
any Product Code. LockXLS offers you to remember all your product codes, and if your want, LockXLS can generate random Product Code for you.
Press ... button near Product Code edit box to open Product Selection dialog:
Your customer should have a 30-day evaluation period. Enter 30 in the Ask activation after  days edit box.
End User License Agreement
Our product should have an End User License Agreement. We've used WordPad to prepare rtf file which contains text of
simple EULA. This is not a valid License Agreement, just an example. You can find this file in the LockXLS Sample Project folder. Show End User License Agreement link opens
EULA Options dialog. Select eula.rtf file using ... button.
Time Selection Options
Open Time Selection Options using Select how LockXLS should determine current time hyperlink.
There are 3 options. You can select any of them, in our example we leave default value - use system clock on customer's PC.
Remind Customer About Registration
We want to remind our customer about registration each day during last 10 days of his evaluation period.
Use Remind customer about registration to open Reminder Options dialog, check both options and
enter options - remind each 1 day and remind when less then 10 days.
Enter message to remind about registration, from ReminderMessage.rtf.
This message uses \expires tag to display expiration timeout. LockXLS Runtime replace it with actual number of days.
Your customer will see the following message:
Please note, when you launch this application reminder is not shown on first start. In this project we've selected
30 days trial period and reminder is shown when trial period is less then 10 days. So, you will see reminder only on 21-st
Customize Activation Messages
On the last step we will provide our own messages, which will be shown to customer in different cases. Use
Customize Activation Messages link to open dialog with messages:
In this example we add messages shown when trial period expires and customer must enter Activation Code, and message for successful activation.
We've used WordPad to create 2 files AskForActivationCode.rtf and SuccessfulActivation.rtf. Both of them are in the LockXLS Sample Project
Now click on the first link and select AskForActivationCode.rtf file by clicking ... button.
Then click on the Message for successful activation ... link and select SuccessfulActivation.rtf
Project is ready.
Now save your project, rebuild it and test.
Run Example_Locked.exe from the LockXLS Sample Project folder. At first
you will see splash window, then End User License Agreement
After accepting EULA - protected workbook is opened. Close Excel and run Example_Locked.exe it again. Now there will
be no EULA window - it is shown only once.
Then, open Adjust Date\Time dialog on your PC and change data to the month ahead. Now evaluation period of our file should expire,
launch it, it will ask you for Activation Code:
Generate Activation Code using LockXLS Activation Code Generator and copy it into this window. Now you see message about successful activation:
Rollback your date in the Adjust Date\Time dialog.
This example shows you how to create a protected file which has EULA, splash and other options. We recommend you to review other topics in this file,
also, the How to ... topic, which was created by the questions from our customers.
Compare Excel Workbooks and VBA Projects
xlCompare - Compare and merge Excel Workbooks, Worksheets, Names and VBA projects, including
macros, forms and controls. 10+ Time saving commands.
Compile Excel workbook to EXE file
Looking for simple Excel Compiler? Visit xlCompiler website. Compile Excel workbook to standalone application.
Excel is not required.
Find out where result of a formula cames from
Dependency Auditor - Analyze and trace dependencies and
calculations in your workbook.
Complete list of the Spreadsheet Tools products
Visit Spreadsheet Tools home page to see
complete list of our products and company information.