How to protect VBA code and VBA project. By default, Microsoft Excel offers VBA project password protection as a way to protect VBA code. This method of VBA.

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. First of all you need to open the file you want to crack and save it as Excel 97-2003 Workbook (*.xls). Then close the file. Now download and install one of the Hex Editor programs – I personally recommend.

Follow the below described steps: Run HxD and go to File > Open, browse for your file and open it. Go to Search > Replace and replace “ DPB=” with “ DPx=“. Go to File > Save and exit HxD.

Open your Excel file – you will get a message saying that the project file contains invalid key ‘DPx’ and you will be asked if you want to continue to load the project – click Yes. Then you will get several messages informing about unexpected errors – click OK until the messages stop showing. Mnemotablici dlya detej.

Now go to Developer tab > Visual Basic > Tools > VBA Project Properties > Protection tab, make sure that you put a tick next to Lock project for viewing, type your own password, click OK and Save the workbook. This is an important step!

You have to set a new password for the project at least for now – else you will be getting errors each time you open the file! Now close and reopen your workbook and you are ready to go! You can leave the password that you set up or go to Project Properties once again and unlock it. If you want to make your project really uncrackable see. Hope that helps!