How to unlock Protected Excel VBA Project and Macro codes without password
Doesn’t work? Try this tool –
If this solution doesn’t work, try removing password from VBA project online
Title: How to unlock Protected Excel VBA Project Macro codes without password or using any paid software
If you need my assistance to unlock the Excel VBA, I’m offering this as paid service. I’m charging $5/Workbook. Kindly get in touch with me
Blog:
Facebook Page:
Recommended Excel VBA books
===================================================
====================================================
If you have ever forgotten a password for the VBA Projects then you know how frustrating that can be. No needs to worry any more and in this video, you’ll learn how to unlock VBA Project and codes which get stored in it. In this method, you no need to use any paid software to unlock VBA Macro Code.
You can download the free Hex Editor tool from
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
Unzip the zip file. Go to xl folder and inside that you’ll find a binary file called “vbaproject.bin”
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 but with extension .xls
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!!!
Nguồn: https://corecplusplustutorial.com/
Xem thêm bài viết khác: https://corecplusplustutorial.com/giai-tri/
Xem thêm Bài Viết:
- Regular Show S8 – Tập 23 – Trau Dồi Học Hỏi Là Mẹ Thành Công – Hoạt Hình Thuyết Minh Tiếng Việt
- CẬN CẢNH MỀU VÀ REDHOOD TROLL CHỊ PANDA BẰNG TNT TRỰC TIẾP TRÊN STREAM | Mều Stream Troll chị Panda
- CAUGHT “HAVING FUN” (NSFW) | Reddit Stories
- Nioh 2 仁王2 | 20 More Popular Character Creation Codes 2
- K/DA – POP/STARS (ft. Madison Beer, (G)I-DLE, Jaira Burns) | Music Video – League of Legends
Comments
I hope this helps someone. Using Winrar, i only toke the Bin file out, did the DPB part and put it back. For any reason, i had to do the DPB part two times. Either did not save properly the first time or it has two DPB that have to be changed.
Sir plz help me i have VBA File it shows workbook expired what i do now.
And my VBA file show only name not .xlsm
Hiw it showes
Legend. works in 2020.
After watching more than 20-30 videos on this subject, I finally unprotected my forget password sheet Thanks Sir Really Helpful and save my work
after trying everything , it worked!
Thanks Brother !!!! you save me.
If the file is an xltm (template file) performing these steps and then zipping it back into a .xltm will just crash excel and not work. However you can zip the file back together with a .xls extension and it works 😀 Just a heads up for anyone else in that boat.
Thanks for the good guide @Amarindaz
@Amarindaz . hi , how did you close that "unexpected error (402320). it is not going for me
thanks… super .. it was worked…
I have .xls file and converting it to .zip file, it is not further get extracted
Doing that in MAC not works. For the HEX editor, I've using HEX friend.
Great help !
is there a way to protect my project against this method?
but it is showing below error and removing vba part. please guide…………….
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
Thanks a lot
Thanks 🙂 a lot it worked well
Yes it works for me.Thank u so much
To Unlock password online ➜ https://bit.ly/crackExcelVBApassword
thank you so mush
It works perfectly, thanks a lot.
This worked exactly as described. I needed to modify the VBscript to change the output path of the file from using Windows backslashes to Unix-Linux forward slashes, and it worked great. The original creator of the script is no longer available and we did not have the password. Nice going!!!
Followed your steps EXACTLY, and when I am at 5:34, I get a prompt in Excel about "Dynamic Data Exchange"?
Tuve que hacerlo 3 veces, en lugar de usar x, usar "X" en mayúscula, teniendo así DPX en lugar de DPx, y funciono! un éxito gracias! probado en excel 2016 y usando HxD como editor hex.
vbaProject.bin shows as vlc media file type (99kb). Hex Editor tool is installed…
working on 2019 excel version?
can't find DPB using MAC, hex friend editor, please help
when i zip the file and try to unzip it "the file unknown format or damaged"
Thanks for the video, you saved me. All good to you
Unexpected error(40230) when view code
doesn't worked on ms 19 excel,any idea?
Works like a charm! Amazing. Thank you!!!
Thanks Mate
Can I ask you how to unlock the VBA file with the "Unviewable" extension . Thanks
You can also just use Notepad++ if you do not already have a hex editor installed. It works the same but might be easier for most people. I have a tutorial on my channel if you want to check out that method also.
THANKS A LOT DEAR….KEEP WORKING LIKE THIS….
Thanks a lot.. it worked 👍👍
Hi In my macro step6 is not visible, It is also locked how to proceed further in that case
yes
Fantastic! Thank you sir!
This is sick!
good. terima kasih from indonesia sir…🤝🤝