We publish here the code table ColorIndex property, these codes will be missed to the users of XlsWorkbookSecuring V1.2.8, in addition to this version we fix some minor bugs and made it compatible with the 64bit version of Excel.

In this version were also added three more display elements in the matrix of protection and viewing:

GridlineColor (color of grid lines)

MoveAfterReturnDirection Down (default markup without the matrix assumes to
 right, if you want the cursor to move down will have to check the option)

Worksheet to select after login / protect (the (s) administrator (s) may mark the sheet that
 want to be selected after login or after protect the workbook)

To use the element GridlineColor, the (s) administrator (s) should not be used to mark a character but the color code you want for the grid lines, code colores presented in the table below:

 
1 - Its use is extremely easy, it is a blank template with features advanced copy protection, control users, array of automation to protect and display Excel worksheet in your workbook.

2 - The template is also provided with only the licensing module (1D).

3 - Your compilation exe lets you add several protection features such as:
- Handle the instance and version of Excel that will open with the template
- Strengthening the security of the project and file vba
- Open an own instance without supplements
All these features are customizable.

4 - The template works with a trial license divided into two periods, one of themcustomizable for redistribution by our customers, only available in 3D version.

5 - Expired licenses trial, the template will only work through the registration of a NSL(Serial No. of license) should be required to vg-excel-gest@hotmail.com us by email,watch video on youtube http:// www.youtube.com/watch?v=_FlnI7bp8eU.

6 - To license template you do not acquire credits of licenses but licenses that willconsuming NSL that each request, licenses will be sold in packages, which will be 1 NSL  a very low price.

7 - In the registry to we automatically download the template offer two credits in order to license the license template and continue to experience, if they need more credits, just write to us at vg-excel-gest@hotmail.com we will offer you more credits.

8 - This is still a beta phase of the project, only are to be released two versions of the template 3D s n4 exe (exe version without editing macros, level 4 license) and 1D sexe n4 see on http://vg-excel-gest.blogspot.com/2011/09/tabela-de-versoes-disponiveis-vs.html http://vg-excel-gest-products.weebly.com/3/post/2011/09/-primeira-publicao.html

 
I received an email a few days from Pakistan of a user who is testing theXlsWorkbookSecuring and put me some questions about the use of the template and the licensing system, I'll post here an extract that this response may account for other users on the same issues, will also help to formulate our FAQ which will be published in the near future.

The project in terms of disclosure, is in slow speed because of the feedback we have received from around the world is forcing us to updates to the product, one of them, it will bemore complex and lengthy is the version that can operate in Office14 (Excel 2010) for this 64-bit version works with Office12 vba7 while the 14 and 32bit VBA6 work with, so there arefunctions that have to be completely modified or adapted by the research we've done will notbe an easy task, also found it is possible to write code so that this code vba automatically detect the version and answer with the corresponding code in order not to produce bugs.

We know that reading the manuals can be a chore a little heavy but is absolutely necessary to understand the true scope of this template, there are all the answers to most questions, will berecommended by the Manual Quick start, how it works and advanced manual.

So here's the email:
This project is still in its beta stage, more versions will come up, we are receiving very positive feedback and suggestions for improvement that will make this template to develop a very high level.

We also received information from some people registered in the project that does not work on Office14 XlsWS 64 bits, we tested and confirmed the incompatibility because this version of office works with vba7, so much work must be done until able to make the XlsWS Work with no bugs in this version but we will get for sure.

How does the system of licenses:

When you first open a XlsWS activates a trial license for 15 days (you should always keep a copy of XlsWS unopened for his other projects), when this license stop should in "Licence Panel" click on "Export Request Form SNL" will be created in the same folder of XlsWS a small form in excel file which should open to finish filling, then filled with the required data should send it to vg-excel-gest@hotmail.com.

We will process this file where the CAL will be transformed into NSL (License Serial Number), then a report will be sent to your email address as shown in this link, which explains how to proceed to activate your copy:

http://vg-excel-gest-products.weebly.com/3/post/2011/10/-fivesimple-stepsto-activatecopies-ofxlsworkbooksecuring.html

We will process this file where the CAL will be transformed into NSL (License Serial Number), then a report will be sent to your email address as shown in this link, which explains how to proceed to activate your copy:

When you take one copy of XlsWS to develop a new project must rename it to your liking (through Windows Explorer, the command "save as" is deliberately disable) and places it in a convenient folder, only then should ask the license, the NSL is only valid for the name and location when they clicked "Export request Form SNL" after licensed if you replace any character in the name or address that NSL will no longer be valid, having to order a new NSL, the first NSL will be valid if you return to put the name and address at the same time ordered the first NSL.

People who want to use XlsWS not buy directly licenses, what they buy in the first instance are credits licenses, that will using over time to exhaust this credit.

License credits are selling now in two packages for XlsWS 3ds and a package for the XlsWS 1Ds can see here:

http://vg-excel-gest-products.weebly.com/buy-licenses.html

Right now our main objective is not to sell licenses, but to make that potential user candidates exhaustively test the XlsWS and report errors, give opinions and tell us that according to the philosophy of XlsWS, their specific needs, so we can take full advantage of this stage is still Beta to make develop the product in the meaning of needs of potential users and move on slowly to the next stage, delivering a final product of high quality and flexible, there is still much work to do so.

As such, with the inscription for download that you did on 10/11/15 officially offer you 2 credits for licenses that may be extended if you need more, just to write it to vg-excel-gest @ hotmail.com and tell us as were the first experiments with XlsWS and will offer you the credits you need to continue the experience. The credits now offer never exceeded the expiration and can be consumed even when the project will move to the final stage and professional distribution.

The size of files you can work with the XlsWs is the same as your system is equipped cope, but as stated earlier versions of existing not function in Office14 64bit, I think to work with files larger than 100MB should use this version, i never worked with Excel files with more than 2mg, part of a practice that impose for my projects we take more efficiency if we divide a large project for more than one file.

It's all, I hope you XlsWS be useful, as final advice is to read the manuals provided with the product to understand the true scope of the XlsWS, start with the quick manual and follow up to the advanced manual, it is also important to read the license agreement, if you have questions do not dis you to contact us.


 
You received a copy of XlsWorkbookSecuring and 15 days have passed since its opening question - "And now the template does not open!, I have a project using this template!"

Of course it does not open! The licensing system does not leave open without first registering a serial number valid license (NSL). So it's very simple follow these steps to receive the NSL valid for this copy:

- Open the template will show the panel "License Protection"
- In this panel click "Export Request Form SNL"
- Created a form in Excel in the same folder where the template, you must open the file and fill in the blank fields (in this case e-mail) and the fields are not required so well understand, record and send that file to vg-excel-gest@hotmail.com.
--Wait until you receive your email in a PDF report containing the corresponding NSL and CAL sent to us.
- Finally follow the steps contained in this report to activate your copy definitely.

Important:
After activating your copy should not change anything in your address or name, theNSL will be valid if you do, having to ask for another NSL.
The copies of the XlsWS should only be activated as well when deciding on whichdirectory will be installed and what will be its final name.


Example of an NSL Report:
 
Would you like to control copies of your spreadsheets through an activation key like a software?

Would you like to control the users of those spreadsheets through a register of those users with different privileges, with username and password?

Would you like to protect and view each sheet of this Excel workbook in a different way, custom, fast, efficient and automatic?

This is XlsWorkbookSecuring, a blank Excel workbook with all these features pre-programmed ready for use.

Now if you then develop on this template you want to distribute the book through your license with a trial period for your customers?

With XlsWorkbookSecuring you can assign a trial license for 30 days for your customers to test your spreadsheet, these past thirty days they will have to buy a license to you and only to yo through an activation key.

This template is in its second beta release of version the RC (Release Candidate) is completely free of macro viruses and only contains procedures to meet their features, see the license agreement,  please can test this template and return feedback for those who returned feedback credits offer free licenses.

Fill out this simple form to be able to download the two versions of the product available:
https://docs.google.com/spreadsheet/viewform?formkey=dDZXWmtGY1l5WWtGOHJ3S05OLUI2UlE6MQ

 
We already know that XlsWS have three dimensions of protection,can work only with 1D or 1D +2 D or 1D +2 D +3 D, to simplify thingswe will provide only 1D and 3D versions.

The size 1D (licensing spreadsheet) + 2D (user control) without the matrix of protection not make much sense, since the user control is connected to the matrix of protection but this is an issue that remains for a future post .

The focus of this post is the XlsWS 1D, because of its simplicity, for those who just want to protect an Excel workbook to prevent unauthorized copying.

In summary this template addresses the need for a large percentage of Excel users every day in forums asking the world how they shoulddo to avoid copying their spreadsheets when they want to distribute them.

The answers are very vague and the "Experts and Gurus" sometimesdo not want to uncover the whole cloth, because each one has its own method and more or less secret.

And indeed there is any reason for such reserves, if only not to put in the hands of any "pseudo" advanced user some complex VBA code that can be handled poorly.

So what did VG-EXCEL-GEST?, Through the project BECUL (BaseExcel users to control licensing and copy protection) saw a business opportunity to explore, why not develop a standard system, pre-programmed to serve users Excel, even for those who do not dominate the shape tool including advanced VBA or not, simply having the need to protect Excel books from being copied.There are a few and not many software that do this work but indirectly, and some need an addin or ddl for licenses to take effect, are often expensive and inaccessible to ordinary users of Excel, they are millions.

What we did was to insert the license generation embedded in the template, being completely freed from reliance on any ddl or addin, it is clear that it would be necessary to ensure that the license wasalways controlled every time you open the Excel file.

This is achieved through the compilation will feature the Excel file in executable format (EXE) that allows you to run vba project regardless of the level of macro security.
 
Published in this first post is a table comparing the available versions ofXlsWorkbookSecuring and available soon in relation to the main technical characteristics.

With this table and then they are all available versions, users can choose which version best suited to protect the spreadsheet.
Picture
versions_xlsworkbooksecuring.pdf
File Size: 253 kb
File Type: pdf
Download File