XCell Compiler
Home arrow How-to arrow Securely hide formulas
Sep 07, 2010 at 07:01 AM
Home
News
Compare Features
Awards
How-to
FAQ
EULA
Advanced Search
Securely hide formulas

The main goal of Excel file copy protection is to remove formulas from cells to make them unavailable to anyone. If the formulas are not really secured protected  then anyone who get permission to launch your model, (even if it was protected with password, license key and/or with hardware locking),  may copy all data and formulas (manually or using some Excel Add-In) into another unprotected workbook and use your model without any restrictions.

The DoneEx XCell Compiler compiles all formulas from xls into binary format and remove them from the cells of xls. For now a days this method is the most secure. Even encoding with strong encryption algorithm is not so secure because you should provide decrypt key for user and since this moment your data are decrypted and available for anybody.

  • To check if there are any available formulas in any compiled EXE  you can switch Excel in "Formula Auditing Mode".
      To do this please follow "Main Excel menu" >> "Tools" >> "Formula Auditing" >> "Formula Auditing Mode"

  • To check that formulas are not available from VBA code  you can use the following equation in VBA
      Sheets("sheet name from your workbook").Range("address of cell with formula").formula

The secured formulas protection is available for any type of DoneEx XCell Compiler licenses . To protect your formulas you just need  to compile your xls with DoneEx XCell Compiler. Please see how to compile your model.

 

 

 

Copyright 2005 - 2010 DoneEx .