remove vba password | How to unlock Protected Excel VBA Project and Macro codes without password
ฝัง
- เผยแพร่เมื่อ 22 ส.ค. 2024
- 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: / bentechu
Recommended Excel VBA books
===================================================
Coming soon
Excel template free download
Comming soon
====================================================
If you have ever forgotten a password for the VBA Projects then you know how frustrating that can be. No needs to worry anymore and in this video, you'll learn how to unlock VBA Project and the 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 www.chmaas.hand....
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 with extension .xlsm
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!!!
💼 To Hire Me 👉
👉 btechplaza is a free AI-powered coding assistant that will help you code faster & smarter. It integrates seamlessly with all top editors and IDE. Btechplaza gives you smart completions and documentation while you’re typing. I've been using Kite on VSCode for 6 months and I love it! Check out Kite 👉 Btechplaza.com
Join this channel to get access to perks:
/ @bentech-s
Never miss any tech solutions from us by subscribing through this link: / @bentech-s
In case you missed some of our videos, Check out the one that might help you
______________________________________________________________________________
1. Find someone on facebook using Telephone number • Video
2. How to watch Dstv on your phone • Video
3. How to convert a Facebook profile to a page • Convert Facebook profi...
4. How to view or control your phone on pc • How to Set Up SCRCPY -...
For details, you can visit my blog at www.btechplaza... - แนวปฏิบัติและการใช้ชีวิต
Very useful video, Thank you
Is there a way to secure the VBA code, but there is no solution to unlock it?
Thank you 🙏... Haven't picked your question well Sir
@@bentech-s Thanks for your feedback.
I wanted to say, how can I protect my VBA Project and Macro codes in a different way than the classic one (password protection). Because as you have shown in this video, the usual protection (by a password) can be opened by another user of my workbook
You're welcome. Try this ways
1. Protect Your VBA Code by Making an Add-In
2. Hide VBA Code in a Read-Only File with Access 2007, 10, 13 etc
Thanks a lot 😀😀
@@khaledmezghani3701 Bonjour M. Khaled, puis-je avoir votre contact svp, j'ai le même problème que le votre.🙂
Simple and clever solution to an issue I had. I created a very useful Excel sheet years ago and protected it with a password that I obviously forgot. Thank you for this video.
You're welcome 🤗. Much humbled
I was able to unlock a forgotten password on VBA code with your clear instructions. Greatly appreciate your fine work.
I'm truly humbled by your honest comment, and I'm glad the tutorial was helpful. Thank you!
Tried doing this with Notepad instead of hex editor. I found the "DPB", changed the text and it didn't work. It removed VBA entirely.
Although, worked like a charm with the hex editor. Thank you so much!
Try to open with notepad++, its working
hex can work or not?
@hanin502 Yes, I said it worked with hex editor. With Notepad didn't work even though I found DPB.
Nice..... But... who else here gets a strange feeling? You thought you set a password and you are safe?....
Me
I did exactly that but when i get into vba, my vba code it's lost. What can it be?
Spectacular, it's working. 🥳🥳
Thank you for acknowledging 🙏
Thank you so much, so smooth solution...
You can also watch this with all solutions th-cam.com/video/O8IIAcrgA1w/w-d-xo.html
You're a life saver!!!! Thank you!!!
Ooh I am very much humbled
amazing
you are genius.
Thank you from my heart❤❤❤❤
You're very much welcome and I am humbled 🙏
Very helpful, thank you!
The excel removes VBA project and I can't see any code.
Thank you so much it did work like a charm!!! you got a sub :)
Thank so much for the support
Awesome Brilliant solution that works perfectly, much appreciate
You are awesome, its working, thank youuuuu much
You're welcome Sir 😊
Worked to my surprise. Good job
Thank you. I always try to give working solutions. Unless updates come
Thank you very much. Excellent information.
You're welcome
I lost all my modules running office 365 2024 updates. I used the same Hex editor as in the video too.
If you're facing challenges kindly contact us on the email on about us section of this channel. We can always support you
so practically, there is nothing protected, not worksheet, not workbook and not even through VBA
🙄😃🤐
Thank You, I thought that i lost my 3 Day working Project
Congratulations 👏
did not work for me with .xlsb file...my excel file was save as binary to lessen the file size
Worked to remove the password but the VBA code is gone. I have a backup but it is password protected and when I try to remove the password with this process, the same thing happens (no password but no code as well). What should I do? Thanks!
Hello, thanks for your explanation.
But I do everything you say and in the end the excel does not open. What would it cost me if you unprotected it?
Contact on bangella23@gmail.com
Actually works, thank you!
Thank you. Kindly share
That worked very nicely for me. Thanks.
its work bro. thank you for this content.
Your welcome sir
Excellent teaching Sir thanks. 🇵🇰
Thank you
Thank you for this! Worked for me.
Much humbled 🙏🙏. Please Like and share
Very useful video, Thank you
Much humbled 🙏
Very clear! thanks!
You're welcome
Wow, It worked for xlsm. But when I have tried with xltm it is not may be there is some other method for xltm file.
Thank you. This is for xlsm. Please stay connected for other methods
Awesome, thanks 👍
One stop video is coming soon. How to unlock all types of passwords in excel files
@@bentech-s I did not have the HEX editor so tried with Notepad + and was able to edit the PDB to PDX
It worked really well.
Thank you 🙏
Hi got to the point where you rename the zip file to xlsm and then open. However once past all the warnings I clicked enable macros warning and now the file closes down and won't reopen. I am guessing I should not have clicked enable macros.
Thanks allot man. Really appreciated for this video 💚
Much humbled 🙏
Hai, i need cell to be auto lock with the specific value. Example C1 is 5000 (untill value get 5000 cell should not lock) cell to be lock only in condition =5000, please help
Sorry for the delay. We'll try find a solution for you
Thanks. Usefull !
Thank you
tried the same steps on a word document with no luck unfortunately...
Sorry it doesn't work on word sir
DPB is not editable showing write access denied now what is the solution for this
Awesome Job 👍🏻, But hey, it works only for the first sheet for ".xls" formats after converting to ".xlsm", other two sheets are missing ! Can you help?
Do do sheet by sheet. I.e if you have 10 sheets. Edit all
@@bentech-s Thanks! But i cannot edit the original macro xls file to remove any sheet!!!
This was great!!!! Thank you!😀
Thank you
Brilliant!
Thank you
Excelente aporte, pude recuperar mi información. Buen video
I got it to work the first time, but not the second time.
Eeeh
Thank you very much for your video
how can i do this with a xlam file?
Hi Ben, I followed your video for unlock excel VBA but my excel crashes. I think this is because this was fixed in mine and next versions of excel. Can you unlock the file for me?
Yes, You can use the email on the about us section
@@bentech-s hi Ben, there is no email in the about section, can you write it here?
Let me know where I can find your email or where else I could contact you!
Didn’t work. Says file is corrupt and won’t open.
Sorry
I did this, but ended up losing the modules for the macros. Where did I go wrong?
Hope you have the backup
@bentechug please help if back up is not there , I also lost the module and it's very important all process done but post that module is not visible , please supoort
@@bentech-s@bentechug please help if back up is not there , I also lost the module and it's very important all process done but post that module is not visible , please support
Tks
I forgotten my old project...
Sorry 😔
thanks man! great work!
You're welcome
I have problem when compress to zip back ,how can solve it ?
Hi Toch,
Hope you backed up. You could have not edited the code well. Kindly do with another original copy and edit a code careful.
Hope this helps you 🙏
Thanks
Thank you Shivam. It was a pleasure working with you 😊.
Unfortunately, it did not work well for me. the VBA is all lost and the table formatting is also messed up after unlock
Bro do it , close the file and re open it again ,it will not show the update while the file is opened
Thank you❤👍👍
works, thank you
You're welcome
I have problem with Excel Workbook Password Removal or Recovery, not excel Sheet password... can you help ...?
I will test it.
Thank you 👍
Thank you!!
You're welcome
This method dos not work for me. The GANTT menu don't open?!!
Sorry it didn't help you. May be you're trying to use it for a different issue. Try double check if everything is matching else look for other corresponding tutorials to your problem
Muchas gracias por el video. El único que me pudo ayudar a solucionar mi inconveniente.....
this work for password locked solver xlams?
Hello, I have problem Removed part: Part /xl/vbaProject.bin. (Visual Basic for Applications (VBA)) in the message "excel was able to open the file by reparing or removing the unreadable content." :(
I have the same issue, has the problem been fixed? Would you please share it ? Thanks.
Share on bangella23@gmail.com
when i change the file extention to zip and then i extract it then there is no XL file. what i can do now ?
same
It worked, thanks bro
Thank you for acknowledging. Much humbled
sir i need one help, not able to editing for HxD software what can i do sir
Send to bangella23@gmail.com
Hi bro while accessing bin file it shows access denied unable to change dpb as dpx what I do
Hello... Never received such a report yet but kindly try using admin user
how to hide module macro gms ?
showing no files found when extracted
I could not see the vbaprotection, etc... Would u mind if i sent u my file and opened it for me pls?
Please contact using email on about us page in this channel
i am able to open the excel file but the macro code is gone
Hope you backed up
would you share your excel file? I like your project :)
I couldn't find dbp, is there any other way to resolve this?
Could be how you searched. Kindly double check the spelling or spacing
Can this work on gms files?
thankkkkkkkk youuu ♥♥♥
it worked.. :)
Thank you 🙏
😱😱😱😱😱 good one
Thank you 🙏
Hi sir can you unlock my VBA ❤ please ❤
Use contact email on the about section of this channel. We'll response accordingly
@@bentech-s thank ❤️
sorry for me no luck, can I sent the xlsm file for you ?
It's fine. I'll respond within 24hrs. Please use email from about page r visit out website
I CANT FIND DPB IN HEX editor
Check spellings or close everything and start afresh. You'll always get if you follow right procedures
thaaaaaaaaaaaaaank you
You're welcome sir
The all methods wrong, there no way to Remove the password
Sorry if this didn't help you. But it perfectly works. Would you mind sharing on our contact email in about us page
Perfect, Thumps up😇
Thank you 😊
Is there any macro Code
Is there a macro Code
sorry for me no luck, can I sent the xlsm file for you ?
It's ok. bangella23@gmail.com
wow Thank you for this! Worked for me.
Much humbled. Thank you for the update 😊