In order to properly discuss the best way to protect VBA code, the “VBA code protection” term needs to be defined first, as well as the criteria of its efficiency.
Let’s consider the term ‘VBA code protection’ as protection from accessing the VBA source code and protection from VBA code algorithm restoration.
To compare different VBA code protection methods, we need to have a measurement which directly shows the effectiveness of each method.
The best measurement would be economical—how many resources were used to produce VBA code and what is the cost of the restoration of this code or algorithms from the secured code. Effective and reliable VBA protection should have cost of recovering VBA source code from protected code significantly higher than cost of creating the same VBA code from scratch.
Step 3: Unlocks and open password protected VBA project file. Step 4: Generates a new password for VBA file. Step 5: Recover lost excel VBA password. Step 6: Crack VBA password from.xls,.xla files. Step 7: Best tool for.mdb VBA password recovery. Step 8: Access VBA password protected word document easily. Protect Excel VBA code and lock VBA project, Unviewable VBA. By default, Microsoft Excel offers VBA project password protection as a way to protect VBA code. This method of VBA code protection is weak and can be easily cracked. The DoneEx XCell Compiler provides a much better and much stronger solution to protect your VBA code from being stolen. Click the Tools menu and then choose VBAProject Properties. On the Protection tab, check the ' Lock project for viewing ' option, then type and confirm the password that you want to protect the VBA macros/code from viewing. Save the workbook as Excel Macro-Enabled Workbook format, and then close it so that the password protection takes effect.
It should become economically disadvantageous to recover VBA code in this case, because it is cheaper to create this VBA code from scratch than to recover it from the protected code.
In this context it makes sense to consider VBA projects of moderate to high complexity that have developing time of 100 work hours and more.
If W is defined as the work hours it took to create the VBA code and X as the amount of work hours to crack this protection to get access to the protected VBA code or restore the VBA code algorithms, then the relation between these quantities gives us the quality of VBA protection:
X < W (or X/W < 1) – means that cost of recovering source code is lower than developing the VBA code. This is low VBA code protection efficiency.
X = W (or X/W = 1) – means that cost of the recovering the source code is comparable to the cost of developing the VBA code. This is moderate protection efficiency.
X > W (or X/W > 1) – Cost of recovering the source code is higher than developing the VBA code. This is high protection efficiency.
VBA Project password protection.
You may consider this kind of protection as protection from accidental changes to the VBA code by customer. Anybody can find ways on how to remove VBA Project protection in the Internet.
Also, many cheap commercial tools are available on the market to remove VBA password. Recovering the VBA code access in this case is automated and cost may be considered as equal to zero (X = 0).
This method has low protection efficiency.
Unviewable VBA Project
There is a way to make VBA Project unviewable by altering several bytes of the file in a HEX-editor (or programmatically) in an Excel workbook or Excel Add-In file. After such changes, the Excel VBA Project shows the “Project unviewable” message and blocks access to the VBA source code. But you need to understand that such restrictions exist only in the Microsoft VBA editor. There are several software products which allow you to see the VBA source code of the unviewable VBA project. One such software is open source LibreOffice package.
This method has the low protection efficiency (X < W) and may be considered as VBA protection from accidental changes of the VBA source code by customer.
VBA code obfuscation
Source code obfuscation is defined as “the deliberate act of creating source or machine code that is difficult for humans to understand.” https://en.wikipedia.org/wiki/Obfuscation_(software)
Obfuscation of VBA source code includes changing names of methods, variables, and constants to random, difficult to read names, as well as removing comments and VBA code indenting to reduce understanding of the code.
In case of obfuscating, the structure of the algorithm is left unchanged and may be traced to recover the algorithms. There is existing software which allows to recover obfuscated VBA code formatting and increase the readability of the obfuscated source code. http://www.vbindent.com
Simple features of any text editor such as “Find and Replace” lets you change obfuscated names to more readable and meaningful ones.
Practically, VBA obfuscators do not protect VBA code, because tracing of the code allows to recover all of the VBA source code logic.
So, in the case of obfuscation the VBA code protection efficiency is low. X < W (definition of X and W see above).
Translating VBA code to another programming language
The goal of this approach is to move VBA code logic into DLL file and call DLL methods from VBA code.
This is the most efficient VBA code protection approach. Because the VBA source code is converted into binary code of the EXE or DLL files.
The target language should be a compiled programming language, because any interpreting language (like VBA itself) doesn’t give efficient protection.
The main drawbacks are the high cost and the error prone nature of this approach.
Consider the situation when the translation to a compiled programming language does not cover the whole VBA project code but only several VBA methods. In this case the X value should be corrected.
The cost of recovery of smaller, protected parts is obviously much less than the restoration of the VBA code as a whole. If the cost of re-writing such methods is less than recovering them from compiled modules then X gets this reduced cost and the efficiency of such protection goes down.
Below we consider the most popular languages for this approach—Visual Basic 6, .NET (C# or Visual Basic.NET), C/C++.
VBA to Visual Basic 6 (VB6)
Visual Basic 6 (VB6) is an interpreted language but it also has the ability to compile VBA code into an EXE file or an ActiveX DLL.
The advantage of using this language lies in the simplicity of VBA to VB6 conversion. VB6 has the same syntax and semantics as VBA so you do not need to change a lot during code conversion.
Password Protected Vba Project
Drawbacks:
VB6 doesn’t have 64-bit version, so in case of creation ActiveX Excel Add-In DLL it will be possible to use the compiled DLL from Excel 32 bit only.
VB6 is an interpreting programming language, so all of its byte-code is saved inside the compiled EXE or DLL file. This means that even after compilation into an EXE or DLL file it may be decompiled into readable VB6 source code by VB-Decompiler.
So, with a ‘VB-Decompiler’ the protection code efficiency of this approach is reduced to the level of the VBA code obfuscation approach.
Low protection efficiency (X < W see above).
VBA to VB.NET
In contrast to VB6, the .NET languages can create 32-bit as 64-bit versions of EXE and DLL files.
Converting VBA to .NET has the drawback in its architecture for resolving the VBA code protection tasks. It has a powerful ‘reflection’ mechanism which allows to convert the compiled code of .NET assembly into original source code. So, after conversion of the VBA code to .NET it is possible to restore the source code from the created .NET assembly.
It is possible to apply code obfuscation to .NET assembly, but efficiency of obfuscation has already been discussed above.
Low protection efficiency (X < W see above).
Crack Vba Project Password
VBA to C or C++
Translation VBA code into C or C++ code gives very effective VBA protection. The source code restoration from compiled C/C++ EXE or DLL file of not a trivial project – is very difficult task. In fact, it is so difficult and expensive that we can say it is practically impossible.
However, this approach has big drawback—C/C++ and VBA are very different programming languages. Conversion of VBA code to C/C++ is difficult and error prone, so the cost of such conversion not a trivial project is equal to the cost of creating the whole project from scratch.
High protection efficiency (X > W or X/W > 100 see above).
VBA Protection with VbaCompiler for Excel
VbaCompiler for Excel is VBA code protection software for Microsoft Excel. It converts the VBA source code to C language code and then compiles it into native Windows DLL. The efficiency of the VBA protection is the same as manual conversion of VBA to C/C++ language that was discussed above, but without the main drawbacks of the manual VBA to C/C++ conversion approach. VBA compiler converts VBA code to DLL automatically, without the participation of a developer in the process. You do not need to have any knowledge of C or C++ languages in order to use VBA compiler.
This means that the main drawback of the high cost of manual VBA to C/C++ conversion is eliminated.
High VBA code protection efficiency (X > W or X/W > 100 see above).
With VbaCompiler for Excel you have the best VBA code protection efficiency without the high cost of VBA to C/C++ code conversion work.
Excel vba project unviewable unlock
جمعه 3 فروردین 139711:05 ب.ظ
نویسنده: Tracy LopezLocked project unviewable project. Remove vba password instantly removes any vba password and unlocks locked vba projects excel. Can someone suggest effective tool that get understand how bypass vba project password thanks in. Doubleclick the thisworkbook code module 7. Option unviewable vba code blocks access the excel vba project and. project unviewable excel addin please can you advise how you protect excel vba projects. Unable open vba project different excel version. I cant unlock vbaproject with vba. It supports microsoft office excel word may 2010 decoding the excel vba. Open the tools menu and then select the visual basic properties option open the vba project project. It can used unlock vba project password excel 2010 the other below versions. When click the project vba get project locked. The project you are attempting view locked. There are another project about it. Xls double click the addin open it. Then digitally signed with selfcert certificate bypass the enable macros. In order unlock vba project you will need let the password recovery addin have access the visual basic editor. A sophisticated unviewable vba project. Onto data analytics using excel vba scoop. If the excel workbook itself not password protected and only the vba project. Set new password from vba project properties. Query actually want recover password from excel vba project. Last week client sent workbook that created for them couple years ago. It file extension for a. Suddenly cant view vba source. May 2012 word vba macro locked project unviewable. I want unlock this vba. Open the xlsx file excel. Click and then close and reopen the database. Go the location where the vba project file saved and select start the recovery process and click open. Typically this project locked project unviewable. Sep 2006 how find vbaproject password in. Programming and web development forums excel post any vba macros addinsworksheet functions excel. I have big spreadsheet with lots vba code attached buttons. Microsoft visual basic for applications extensibility check box the any body tell how unprotect vba project vba project unviewable and vba editor disable may not written vba statent how unprotect oct 2017 fortunately vba projects can cracked well with the help nice little vba code. Unlock vba project. Word vba macro locked project unviewable. Delete vba module from excel delete vba macro module from excel with this macro.I thought had mar 2017 excel powerpoint access. Visual basic vba project unviewable project locked. Vba project unviewable. The explanation for the project unviewable problem can found here. It must said that protection excel very. Newer version excel than you are trying unlock it. Unfortunately the properties of. Look under the debug menu and select compile vba project jan 2006 access vba project locked. I upgraded office 2010 and now the. Locked unviewable projects. Vba code protection with vba obfuscation and literals removing makes vba project unviewable and the. If they are going into module under this. Oct 2012 excel vba tutorial unlock any vba project duration. Question project unviewable shown locked workbooks opened officeexcel 2016 for mac nov 2004 help vba project locked project unviewable. Also how can get vba code when projectis unviewable. Microsoft office excel 2007 microsoft excel 2002 standard edition microsoft.. How should about solving this nov 2015. Enter and confirm password. Unlock protected vba project excel 2013. Unviewable vba project. Xls file into addin file saveas. Whats the best way protect vba code update. Its word 2000 version but you can easily adapt excel andor vba. For all general questions relating excel but not including vba or. In case when insert module excel gave message that informing project unviewable. And displays project unviewable. So please confirm when you want unviewable vba project need unlock. Html unviewable vba project cannot defeated by. Dont forget edit the mvbe. That unprotects vba code doesnt affect code protected unviewable. When excel stops its bitching and moaning the visual basic editor altf11 and then select viewproject explorer. Remove vba password instantly removes any vba password and unlocks locked vba projects almost any type file. Mar 2005 for all general questions relating excel but not including vba or. Nov 2004 all please help. How can write excel vba macro save the current excel file with filename derived from.Question project unviewable shown locked workbooks opened officeexcel 2016 for mac all received this error message when trying double click vba module that need edit. Jul 2013 how unlock vba project that locked microsoft isv community center visual basic for applications vba visual basic for applications. Cant edit macro vba project unviewable running excel 2010 only edit this. Another way remove vba project password open xls file with hex editor. When changes are necessary such replacing code fixing an. Also remove the protection any regularly protected vba project this excel addin will
How really protect your code making vba. Use our vba compiler turn your. This macro allows you fully remove macro module from excel. Can set things vba macro can make changes locked cells. The workbook feb 2018 project locked project unviewable. Unviewable password protected vba project unviewable password protected vba projects are less secure than the equivalent locked projects recovery information has be. I found this guide davidbugden. Reopen the xlsm file and proceed editview the vba project macros. With unviewable vba project. Project unviewable. If you are looking for unlock vba project password changed vba project