Recover or break vba password for Microsoft Excel file
Sometimes I need to recover or break the VBA password for an excel file because I build some code inside excel files and protect the file with a vba password just to keep my colleagues from ruining the code behind the excel reports. There are times when I don’t pay attention to the password thinking it is a one off file and I don’t need it in the future.
How to break or recover VBA password
I will tell you how I do it in a few simple steps.
change the file extension from xlsm to zip
open the zip file with winzip or winrar
go to xl folder
find the vbaProject.bin file
extract the file on desktop
edit it with some Hex Editor (HxD editor is free)
search for DPB string inside the file
replace DPB with DPx and save
copy the file back inside the archive
change the file extension back to xlsm
open the file and skip the warning messages
go to vba project properties and protect the file with a new password
save the file and reopen it
That’s all you have to do to recover the vba password. More like a break of passwords.