Belahanajima - Tin tức nóng nhất trong ngày đa dạng chủ đề
  • Home
  • Phong Thủy
  • Học Tiếng Anh
  • Công Nghệ
No Result
View All Result
Thursday, December 16, 2021
  • Home
  • Phong Thủy
  • Học Tiếng Anh
  • Công Nghệ
No Result
View All Result
Belahanajima - Tin tức nóng nhất trong ngày đa dạng chủ đề
No Result
View All Result

How to unlock Protected Excel VBA Project and Macro codes without password

admin by admin
July 3, 2020
in Công Nghệ
43
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://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
Previous Post

I love this game! - NFS San Andreas (MTA) #1 | Let's Play

Next Post

HÀ LAN - PHAN MẠNH QUỲNH | MẮT BIẾC OST

Next Post
HÀ LAN – PHAN MẠNH QUỲNH | MẮT BIẾC OST

HÀ LAN - PHAN MẠNH QUỲNH | MẮT BIẾC OST

Comments 43

  1. Vinod Bangar says:
    1 year ago

    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

    Reply
  2. Dante Fajardo says:
    1 year ago

    after trying everything , it worked!

    Reply
  3. aap ka apna says:
    1 year ago

    Thanks Brother !!!! you save me.

    Reply
  4. FiniteTurtles says:
    1 year ago

    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

    Reply
  5. Dhivya Narayanasamy says:
    1 year ago

    @Amarindaz . hi , how did you close that "unexpected error (402320). it is not going for me

    Reply
  6. Devops -RSundar Tool videos and Latest updates says:
    1 year ago

    thanks… super .. it was worked…

    Reply
  7. Pathan Sohel says:
    1 year ago

    I have .xls file and converting it to .zip file, it is not further get extracted

    Reply
  8. Leonardo Sanchez says:
    1 year ago

    Doing that in MAC not works. For the HEX editor, I've using HEX friend.

    Reply
  9. Victor Ramos says:
    1 year ago

    Great help !

    Reply
  10. Smart Planilhas says:
    1 year ago

    is there a way to protect my project against this method?

    Reply
  11. RAVI SHARMA says:
    1 year ago

    but it is showing below error and removing vba part. please guide…………….

    Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))

    Reply
  12. Phú Nguyễn says:
    1 year ago

    Thanks a lot

    Reply
  13. Deepa Mohan says:
    1 year ago

    Thanks 🙂 a lot it worked well

    Reply
  14. Vikram says:
    1 year ago

    Yes it works for me.Thank u so much

    Reply
  15. Amarindaz says:
    1 year ago

    To Unlock password online ➜ https://bit.ly/crackExcelVBApassword

    Reply
  16. Abdulla Jassim says:
    1 year ago

    thank you so mush

    Reply
  17. George Khachof says:
    1 year ago

    It works perfectly, thanks a lot.

    Reply
  18. Mac Spt says:
    1 year ago

    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!!!

    Reply
  19. Chris R says:
    1 year ago

    Followed your steps EXACTLY, and when I am at 5:34, I get a prompt in Excel about "Dynamic Data Exchange"?

    Reply
  20. Samuel Leiton says:
    1 year ago

    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.

    Reply
  21. Alok Ghosh says:
    1 year ago

    vbaProject.bin shows as vlc media file type (99kb). Hex Editor tool is installed…

    Reply
  22. Michael Salazar says:
    1 year ago

    working on 2019 excel version?

    Reply
  23. Kepo Syariah says:
    1 year ago

    can't find DPB using MAC, hex friend editor, please help

    Reply
  24. Ehab Freiha says:
    1 year ago

    when i zip the file and try to unzip it "the file unknown format or damaged"

    Reply
  25. Miroslav Triebel says:
    1 year ago

    Thanks for the video, you saved me. All good to you

    Reply
  26. Satari My Village says:
    1 year ago

    Unexpected error(40230) when view code

    Reply
  27. Veli Can Yesil says:
    1 year ago

    doesn't worked on ms 19 excel,any idea?

    Reply
  28. g4m4de says:
    1 year ago

    Works like a charm! Amazing. Thank you!!!

    Reply
  29. John Snow says:
    1 year ago

    Thanks Mate

    Reply
  30. Duy Nguyễn says:
    1 year ago

    Can I ask you how to unlock the VBA file with the "Unviewable" extension . Thanks

    Reply
  31. ReedisMLG says:
    1 year ago

    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.

    Reply
  32. Suresh Ghori says:
    1 year ago

    THANKS A LOT DEAR….KEEP WORKING LIKE THIS….

    Reply
  33. Yogesh Nirmal says:
    1 year ago

    Thanks a lot.. it worked 👍👍

    Reply
  34. Neha Shroff says:
    1 year ago

    Hi In my macro step6 is not visible, It is also locked how to proceed further in that case

    Reply
  35. Garments process development says:
    1 year ago

    yes

    Reply
  36. Odilon says:
    1 year ago

    Fantastic! Thank you sir!

    Reply
  37. Enrike Kasijas says:
    1 year ago

    This is sick!

    Reply
  38. Jack Separow says:
    1 year ago

    good. terima kasih from indonesia sir…🤝🤝

    Reply
  39. Hon Kei Ma says:
    1 year ago

    You save my day

    Reply
  40. REYLAAA ! says:
    1 year ago

    100% working, thanks

    Reply
  41. Raftar Rr says:
    1 year ago

    XLs file is not creating while extracted from win rar zip

    Reply
  42. Anurenj Das says:
    1 year ago

    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.

    Reply
  43. MsBuddy2000 says:
    1 year ago

    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.

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Xem Thêm

☔ TƯ VẤN MẬU NGỌ 1978 CHỌN HƯỚNG NHÀ, LÀM NHÀ, LÀM BẾP P3 – Phong Thủy XUÂN THỨ

☔ TƯ VẤN MẬU NGỌ 1978 CHỌN HƯỚNG NHÀ, LÀM NHÀ, LÀM BẾP P3 – Phong Thủy XUÂN THỨ

July 3, 2020
☕ CANH TUẤT 1970 CHỌN HƯỚNG Như Thế Nào – Phong Thủy XUÂN THỨ

☕ CANH TUẤT 1970 CHỌN HƯỚNG Như Thế Nào – Phong Thủy XUÂN THỨ

June 30, 2020
☕TÂN HỢI 1971 CHỌN HƯỚNG – Phong Thủy XUÂN THỨ

☕TÂN HỢI 1971 CHỌN HƯỚNG – Phong Thủy XUÂN THỨ

July 6, 2020
☯ NHÂM TUẤT 1982 CHỌN HƯỚNG Kinh Doanh Như Thế Nào – Phong Thủy – Xuân Thứ

☯ NHÂM TUẤT 1982 CHỌN HƯỚNG Kinh Doanh Như Thế Nào – Phong Thủy – Xuân Thứ

June 29, 2020
☯ QUÝ HỢI 1983 Làm Nhà Hướng Nào Tốt – Phong Thủy – Xuân Thứ

☯ QUÝ HỢI 1983 Làm Nhà Hướng Nào Tốt – Phong Thủy – Xuân Thứ

July 4, 2020
☯Mệnh Mộc nên KINH DOANH BUÔN BÁN GÌ, LÀM NGHỀ GÌ ĐỂ PHÁT TÀI🔥TỬ VI SỐ MỆNH

☯Mệnh Mộc nên KINH DOANH BUÔN BÁN GÌ, LÀM NGHỀ GÌ ĐỂ PHÁT TÀI🔥TỬ VI SỐ MỆNH

July 4, 2020
  • Chính Sách Bảo Mật
  • Liên Hệ

© 2021 JNews - Premium WordPress news & magazine theme by Jegtheme.

No Result
View All Result
  • Home
  • Phong Thủy
  • Học Tiếng Anh
  • Công Nghệ

© 2021 JNews - Premium WordPress news & magazine theme by Jegtheme.