Remove MS Excel VBA password

I often work with MS Excel template for different report requirement. Most of the MS Excel template includes VBA procedure, but most of them are protected with password. Below step is to remove the VBA protect passord in MS Excel.

1. Create a new MS Excel document and set the VBA protect password as "1";

2. Open this document from UE/any hex editor. And search "43 4D 47" - CMG. like below

CMG="7270DE6E5472547254725472"
DPB="E4E648E0C853C953C953"
GC="5654FA721E96919791976E"

3. Close this document, and open the target VBA protect document in UE/any hex editor.

4. Replace the same section with above values.

5. Save this document. And reopen it with MS Excel.

6. The VBA password will be changed to your new password "1", or even it will not ask for password.

 

Or

Open the target document and change the DPB = DPm and save the document.

After that, reopen this document in MS Excel, it will show key issue, ignore it and open this document and reset the password.