remove vba password | How to unlock Protected Excel VBA Project and Macro codes without password

Title: How to unlock Protected Excel VBA Project Macro codes without password or using any paid software

Recommended Excel VBA books
===================================================
Coming soon
Excel template free download
Comming soon
====================================================
If you have ever forgotten a password for the VBA Projects then you know how frustrating that can be. No needs to worry anymore and in this video, you'll learn how to unlock VBA Project and the codes which get stored in it. In this method, you no need to use any paid software to unlock VBA Macro Code.

Follow the below simple steps to unlock the Protected Excel VBA project

Step 1
Make a copy of your Macro enabled xlsm workbook.

Step 2
Change the file format of the Macro-enabled workbook from xlsm to zip

Step 3

Step 4
Open the VBA Project binary file using Hex editor. Find the word "DPB" and replace that with "DPx". Save the VBA Project binary file and close it

Step 5
Come back and zip it again with any naming convention with extension .xlsm

Step 6
Go to VBA Project- Tools- VBA Project properties. Unchecked the option Lock project for viewing in the Protection tab. Save and close the workbook

Step 7
Open the same workbook and now you can able to see the Modules and code reside in that. Congratulations You've successfully unlocked the VBA project code without using the password

Please let me know if you have any doubts. Please subscribe!!!

Join this channel to get access to perks:

In case you missed some of our videos, Check out the one that might help you
______________________________________________________________________________

[khaledmezghani]

Very useful video, Thank you
Is there a way to secure the VBA code, but there is no solution to unlock it?

[sinnasamynaidu]

I was able to unlock a forgotten password on VBA code with your clear instructions. Greatly appreciate your fine work.

[tadashitani]

Simple and clever solution to an issue I had. I created a very useful Excel sheet years ago and protected it with a password that I obviously forgot. Thank you for this video.

[nairobi]

But... who else here gets a strange feeling? You thought you set a password and you are safe?....

[ionescuiulian]

Tried doing this with Notepad instead of hex editor. I found the "DPB", changed the text and it didn't work. It removed VBA entirely.
Although, worked like a charm with the hex editor. Thank you so much!

[JoaoPedro-pxsj]

I did exactly that but when i get into vba, my vba code it's lost. What can it be?

[carlo_Photoshoplover]

did not work for me with .xlsb file...my excel file was save as binary to lessen the file size

[inesdiazcurull]

Worked to remove the password but the VBA code is gone. I have a backup but it is password protected and when I try to remove the password with this process, the same thing happens (no password but no code as well). What should I do? Thanks!

[naistudio]

The excel removes VBA project and I can't see any code.

[sedat]

Thank you very much. Excellent information.

[imraanganie]

Awesome Brilliant solution that works perfectly, much appreciate

[SAM-owes]

amazing
you are genius.
Thank you from my heart❤❤❤❤

[JasonHDuctmann]

I lost all my modules running office 365 2024 updates. I used the same Hex editor as in the video too.

[ilkerimrak]

Thank you so much, so smooth solution...

[uanarteme]

Hello, thanks for your explanation.
But I do everything you say and in the end the excel does not open. What would it cost me if you unprotected it?

[ajm]

Hi got to the point where you rename the zip file to xlsm and then open. However once past all the warnings I clicked enable macros warning and now the file closes down and won't reopen. I am guessing I should not have clicked enable macros.

[chrisraymundo]

You're a life saver!!!! Thank you!!!

[sanson]

Thank you so much it did work like a charm!!! you got a sub :)

[amartin]

That worked very nicely for me. Thanks.

[FarhadMMD]

Thank You, I thought that i lost my 3 Day working Project