Giải Trí

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/

Giải Trí
Tiền Trạm Resort 5 Sao Ở Vũng Tàu
Giải Trí
Winrar Forgot Password Recover without any software 1000% working
Giải Trí
Cách giảm dung lượng nhiều ảnh( resize ảnh hàng loạt )bằng Photoshop
  • 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…🤝🤝