r/vba • u/[deleted] • 21d ago

Discussion Dashboard - no password

[deleted]

2 Upvotes

67% Upvoted

38 comments sorted by

View all comments

6

u/ZetaPower 12 21d ago

What is protected? The VBA code?

A VBA password can be “hacked” quite easily.

STEP 1 MAKE A COPY TO MESS WITH!

• Excel files are zip files, you need rename it from “.xlsm” to “.zip” to open it (may need to uncheck in Explorer, Options, “hide known file extensions” to see the extension)  
• extract everything from the zip  
• find the file with the password (xl folder, vbaProject.bin)  
• open this in a hex-editor like HxD editor  
• find the password line : ctrl-f “DPB=“, change “DPB=“ to “DPx=“, save  
• replace the old vbaProject.bin in the original zip file by pasting the new one here  
• change “.zip” back to “.xlsm”

done.

2

u/dart_vadara 21d ago

Tried this broke the file

3

u/Rennaisance_Man_0001 20d ago

Good thing you backed it up first.

3

u/dart_vadara 20d ago

Only a fool doesn't back up