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://belahanajima.com/
Xem thêm bài viết khác: https://belahanajima.com/cong-nghe/
Xem thêm Bài Viết:
- Đánh giá AMD Ryzen 9 5950X và Ryzen 7 5800X: từ làm việc tới chơi game đều đỉnh, không chừa đất sống cho đối thủ
- Hiển thị Repair Your Computer trong Advanced Boot Options trên Windows 7
- How to repair windows 7 and fix corrupt CD/DVD (tutorial)
- How To Repair Windows 10
- Windows Repair (All In One) FREE Repair Program
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…🤝🤝
You save my day
100% working, thanks
XLs file is not creating while extracted from win rar zip
Hello,
I want to password protect and unprotect an excel workbook using VBA. And want the macro to pull the password from another file. Please help me with the code.
Hello Amarindaz, Thanks for your beautiful video. However, I am having problems with searching for DPP using the XV132 Hex Editor (like yours on the video). When I do a search for DPP string, it does not find it. I tried many times but with no success. Kindly help with advice on what to do to resolve this, please. Again thank you.