Remember that if VBA code is protected, it’s protected for a reason. The below described method should not be used to steal someone’s hard word – it can be only applied if you forgot the password to your own VBA project or for educational purposes.
May 27, 2021 Method 2. Crack Excel VBA Project Password with Hex Editor Hex Editor provides you with a good platform to edit hexadecimal goods and finally crack an Excel VBA password. In this method, you will create a dummy xls file, set a password, and use it to access the protected Excel. Step 1: Use the Hex editor to create a new Excel file (xls). Unviewable password protected vba project Unviewable password protected VBA projects are less secure than the equivalent locked projects, as recovery information has to be maintained within the file. Unviewable password protected projects can be made visible and re-locked, if required. I Finally Found It! Unfortunately, the properties of the source VBA project, including its password, cannot be transferred to the target workbook. Thus, the code embedded in the newly copied worksheet will be visible, even if the source VBA project was password locked or custom protected as unviewable or Unviewable+! The workaround for this problem involves 2 steps. While in Visual Basic Editor (VBE), you click on a VBA project and receive the ' Project is unviewable ' error, instead of a password input prompt. You can neither view, nor edit macros. This article presents the 2 main reasons behind this message. We will also show you how you may be able to gain access to the VBA code inside the locked project. How in the world does someone make a VBA project 'unviewable. A project down with a password. Able to enter a password or use any other 'crack. Ron Jan Karel Pieterse 17.01.10 9:50. Rainbowssd5 39 2 exe extractor for android. Hi RonIs there a better more secure way to protect a VBA project? Yes there is (misplaced the link to this one): 1.
This method works with all Excel files and does not require any third party software.
All we need is this piece of code I’ve found on stackoverflow.com. Apparently credit goes to Vietnamese developer nicknamed Siwtom or Đức Thanh Nguyễn and I believe this is his YouTube channel.
All you need to do is to run Sub UnprotectVBA() – this will crack the VBA password on all files currently opened in given Excel instance.
Based on this code I’ve prepared UnlockVBA add-in which can be downloaded from here. It creates an additional button on Developer tab in Excel Ribbon. I’ve made it’s VBA project unviewable using this method.
I will also provide the code here just in case it gets deleted from stackoverflow.
If you want to make your project really uncrackable see this post.
Hope that helps!