Made my life easy. Took me four hours to try every source on internet to reach here. A slight mistake of not saving the file after removing protection caused me so much distress. Thank you it works now
@Amarindaz4 жыл бұрын
Glad it helped!
@wealthy_you3 жыл бұрын
Works in 2021 toooo.. thank a lot sir. You have saved me
@primuseng58225 жыл бұрын
Thank you...I saved one old project I did and forgot password! You are a genius!!
@moharsingh49533 жыл бұрын
My file is lock plz help
@MT4LYF5 жыл бұрын
first time i misunderstood putting a X at DPB. once i did 2nd time and used DPX it worked. thank you very much
@macspt43834 жыл бұрын
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!!!
@maciejbeker62124 жыл бұрын
You can fix the problem with different separators by using this code instead of the separator, this way the macro will adjust to the given system and its not hardcoded to any given system: Application.PathSeparator
@anandar1407 жыл бұрын
My boss has created code and forgot password now i unlocked VBA by your codes Thank you...
@Amarindaz7 жыл бұрын
+Ananda R Glad to hear
@nickiawalker6454 жыл бұрын
This video was king. And helped me unlock a file a seller I paid tried to lock.
@neerajmalik59796 жыл бұрын
Thanks for making this video because this video really helped me to unlock my old VBA protected file. Thanks again.
@Amarindaz6 жыл бұрын
Glad to hear
@kashmiri42094 жыл бұрын
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
@kevindsilva13446 жыл бұрын
i have a excel file with a macros, i want to change the value of of ome of the integers in excel but everytime i click macros, it says 'license information for this component not found, you do not have the appropriate licensceto use this functionality in the design enviornment' any way to go about this?
@Ciera527 жыл бұрын
Thank you. I tried at least 10 different ways to bypass the password code and yours is the only one that worked.
@karolispulokas13646 жыл бұрын
Works like a charm on Excel 2013. Coffee bought. Thanks a lot
@Amarindaz6 жыл бұрын
Glad to hear :)
@Davises126 жыл бұрын
hepl me unlock uloz.to/!MLvVpREbHJyB/sluzebni-cesty-xls?_fid=vqpk????
@IkhwanReza5 жыл бұрын
can't find DPB using MAC, hex friend editor, please help
@123jalluri4 жыл бұрын
Hi I tried with the above, it does not show me the module when I open unlock xls in visual basic editor and I can only see sheets are you able to provide some insight of this. Im using windows 10 excel
@Amarindaz4 жыл бұрын
Not sure what went wrong with your case. I suggest to use online service to unlock instantly bit.ly/unprotect-excel-Workbook
@CR-wk4qt5 жыл бұрын
Followed your steps EXACTLY, and when I am at 5:34, I get a prompt in Excel about "Dynamic Data Exchange"?
@karnadharboro7 жыл бұрын
file corrupt not opening and no xl folder in it
@ThomasJr5 ай бұрын
Hey, you have to disable your end screens, it gets in the way of what we need to see at the end of the video.
@amenell38 жыл бұрын
When I try to open the .xls file, XL tells me that it can't because the file is corrupt.
@Dhannraj2 жыл бұрын
Wonderful. Thank you for putting up this video. Would you be having something similar for PowerPoint Presentations?
@9487nupur2 жыл бұрын
When I changed the xlsm extension by .zip, its not opening in zip. showing error like file damage or not zip file, can anyone help
@joep4life2 жыл бұрын
I have the same problem. Did you manage to solve it?
@abeljeremiah994 жыл бұрын
Thank Master It's Very very to rescue my problem And Done. Thx again.
@g4m4de5 жыл бұрын
Works like a charm! Amazing. Thank you!!!
@luamoura9854 жыл бұрын
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.
@jetli45575 жыл бұрын
I m stuck at one point where pop up appears that 'project file contains an invalid key "DPx" continue loading project. when i press YES button then an error appears "UNEXPECTED ERROR 40230" what would i do now to resolve this error?
@FiniteTurtles4 жыл бұрын
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 :D Just a heads up for anyone else in that boat. Thanks for the good guide @Amarindaz
@blukido57004 жыл бұрын
Thanks man for your video. It did helped me. Already subcribed and bell all :D
@moesadr33424 жыл бұрын
I have an Excel 2019 .xlsm database with over 7 sheets and I have forgot the protection password. How can I either find the password or unprotect all sheets without corrupting the file and/ or macros and modules?
@Amarindaz4 жыл бұрын
In this case I suggest online excel password remover bit.ly/unprotect-excel-Workbook
@thearchibaldtuttle7 жыл бұрын
Funny this worked already with older versions of Excel. I thought Microsoft has made it harder to get around this protection but it seems not. You can also convert the file into a Excel 2003 format (XLS) and open then the file directly with the HEX editor and do the manipulation.
@Jwalker00752 жыл бұрын
Hi, I have lock the VBA files but cannot unlock to see my VBA sheet. Can you help me ?
@karthikannam35887 жыл бұрын
Hi,Xl folder is missing when i zipped the file.Could you help me out?
@OmarAhmed-cm3mv Жыл бұрын
Thank you so much it's simple and effective.
@MultiAssassin1218 жыл бұрын
Daaaaam Worked like a charm. Thank you very much!
@aNDy-qh1em Жыл бұрын
Thank you so much sir. You have made my day!
@vladimir1933 жыл бұрын
Amazing! Still works! :) Thanks a lot
@LearnShine6 жыл бұрын
i couldnt find vbaproject.bin file in my case, how can i proceed
@paperso6966 жыл бұрын
nice, thanks ! fyi, worked as well opening with notepad++ rather than HEX editor (excel 2013)
@dhruvtrivedi92314 жыл бұрын
Hey sir, I have seen your video about crack vba password, that was really cool. I want to learn what is going behind DPB and DPX. Please help me to learn this. Thanks alot.
@frankie30055 жыл бұрын
Thank you very much bro. It still works and it is 2019. Any one who said it is not working in the comment needs to learn how to follow the steps precisely. I was wondering is there a way I can unlock my protected sheet. I locked important sheet years ago and now I don't remember the password
@Amarindaz5 жыл бұрын
You're welcome. Please checkout kzbin.info/www/bejne/rYuonoCmetBjerc for unlocking sheets
@กตติโชติลดาวดี3 жыл бұрын
How to remove old version ".xls"
@selvarasan.v72462 жыл бұрын
Thank you for your good idea and suggestion but I not have this software or any application. But I need, how to other way open this offline and online platform please suggested at trust for you in this regards
@right2money4 жыл бұрын
Simply Wow..!! loved it..!!
@vikram99664 жыл бұрын
Yes it works for me.Thank u so much
@MrChandrasekharreddy7 жыл бұрын
Thank you Amar!! This is really worked
@Baiaaa963 жыл бұрын
Excellent job. I hope it will never get deleted :D
@RAVISHARMA-hn1iv4 жыл бұрын
but it is showing below error and removing vba part. please guide................ Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
@Amarindaz4 жыл бұрын
Please use the online service to unlock VBA password instantly bit.ly/crack-password
@lamvinhha6 жыл бұрын
I tried, but at step find DPB in Hex it show mess "can't find DPB". How can i do? Please help!
@thcarm7 жыл бұрын
Thanks very much mate. I wonder how someone first discovered this
@piyushkataria497 жыл бұрын
I am Doing the same but it shows error "No Archieves Found" when i extract zip Folder. Waiting For your response. Thanks Regards Piyush Katariya Jr. En.-Geotech
@GulshanKumar-zx3bm6 жыл бұрын
Beautifully explained and worked very well. Very helpfull
@nehashroff29905 жыл бұрын
Hi In my macro step6 is not visible, It is also locked how to proceed further in that case
@Amarindaz5 жыл бұрын
Please use the online service to unlock instantly bit.ly/crack-password
@alphaeriortiz46574 жыл бұрын
Thank you sooooo much, you are awesome! totally solved my problem.
@ramzikhouri5 жыл бұрын
must it be Hexeditor. does it work if i open it up in notpad, search and edit it to BDx? (note: i was able to open the vba but did not find any vba in the sheets.)
@krish25197 жыл бұрын
It's was amazing... thanks... Amar :)
@vineetverma91786 жыл бұрын
i saved my 2 weeks because of you. Thank you !!!
4 жыл бұрын
Thank you very much, very useful, but in my case Excel detect an error and remove the vbaProject.bin, how can I workaround to don't remove it?
@aylanmoriarty78932 жыл бұрын
hello, did you find a solution for that! I have the same problem too now :/
@darshanalanka74567 жыл бұрын
Amazing Work bro.... Thanks for this
@Amarindaz7 жыл бұрын
+Darshana Lanka Thank you!
@anurenjdas73535 жыл бұрын
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.
@bratislava_streets3 жыл бұрын
so simple and yet so much helpful, thanks so much
@alokghosh93115 жыл бұрын
vbaProject.bin shows as vlc media file type (99kb). Hex Editor tool is installed...
@incor34802 жыл бұрын
When i try to save the Hex editor it says "this file is set to read only. Try again with a different file name".
@llalbwansingh93622 жыл бұрын
I have problem with Excel Workbook Password Removal or Recovery to Open. Not excel Sheet password...! Can you help ...?
@SimX90003 жыл бұрын
I love you. Working Office 365 2021. Crazy!
@audiobooksbyami63603 жыл бұрын
Thanks so much! It's totally worked!
@anthonymartin35797 жыл бұрын
how come this does not work on a locked project with an xlam for add-ins? I created one that I forgot the password on it.
@psolankurkar2 жыл бұрын
Excellent Video. It worked for me
@sureshghori30815 жыл бұрын
THANKS A LOT DEAR....KEEP WORKING LIKE THIS....
@kingimad62436 жыл бұрын
Pleasr sir i'm looking for a method to remove VBA protection when the macro is disabled from viewing
@yogeshnirmal54165 жыл бұрын
Thanks a lot.. it worked 👍👍
@Achinthac5 жыл бұрын
100% worked for me, thank you very much...
@KhaledYosrykhaled7 жыл бұрын
when i finally open the VB after completing all the steps , it says the VB project is unviewable ,, what to do ?
@esjay124 жыл бұрын
Legend. works in 2020.
@DetailsByVJ7 жыл бұрын
This is not working in 2016 version. If any know to resolve this please let know.
@nizarkhorchani88556 жыл бұрын
download hexeditor and repeat the same actions in the video :)
@murilospineli22416 жыл бұрын
@@nizarkhorchani8855 Don't work!
@nizarkhorchani88556 жыл бұрын
@@murilospineli2241 yes men it s working just download hexaediteur and do the same steps
@murilospineli22416 жыл бұрын
@@nizarkhorchani8855 I'm saying 'cause I tried, but I wasn't able to unlock it, a message appears saying "the macros were corrupted then deleted". I did it exactly as the video, I really need this file can you do it to me? (link was here)
@nizarkhorchani88556 жыл бұрын
@@murilospineli2241 sorry Murilo the workbook is save it as Excel binary workbook (.xlsb) without macros so i cannot give you a hand :(
@MsBuddy20005 жыл бұрын
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.
@owenprice56473 жыл бұрын
"DPB". not "DPP".
@kuldeepmittapally6 жыл бұрын
Sir, I have sent you a message through your website regarding unlocking an xlsb Macro file, still waiting for your response...
@krishikaramaswamy46816 жыл бұрын
This was very helpful. Thank you :)
@aischacelik81613 жыл бұрын
Thank you very much. It is working!!!
@dyer104 жыл бұрын
Anyway to do this on a docm file instead of an xlsm? Cheers.
@thiagos.a.58197 жыл бұрын
Doesn't work. "Erro opening file vbaproject.bin".
@KebbyLL4 жыл бұрын
I was able to get to VBA properties and be able to view all the sheet. But there is not password in module 1
@ashiqmir27173 жыл бұрын
When i extracted there is no XL folder infact there are only 2 folders and 1 file.....
@luisahumada60813 жыл бұрын
It worked dude!!! you save my life... heheheheh... tks
@muciobatista105 жыл бұрын
Hi Amarindaz, your tool unlock sheets and vba modules?
@shailendravishwakarma93352 жыл бұрын
Thanks! It really works 👍
@raftarrr75645 жыл бұрын
XLs file is not creating while extracted from win rar zip
@crfly1on7 жыл бұрын
When I get to the VBA screen, I keep getting "Project is unviewable". Can you help?
@miroslavtriebel81265 жыл бұрын
Thanks for the video, you saved me. All good to you
@adetoyeseakanbi97683 жыл бұрын
After changing the file name, right clicking is not giving extract all option
@vefeye5 жыл бұрын
doesn't worked on ms 19 excel,any idea?
@Amarindaz5 жыл бұрын
Please use the online service to unlock instantly bit.ly/crack-password
@bezuchof6 жыл бұрын
Thanks a million! Very clear and it works, this is great.
@Amarindaz6 жыл бұрын
You're welcome :)
@bpoojajain94085 жыл бұрын
I have project containing more folders then the normal like drawing and printer setting folders. Can you please say me how to unlock that ? This video of you was really very useful for many thing thank you!!
@chinhphan81275 жыл бұрын
Link you
@LeonardoSanchez-ig2pm4 жыл бұрын
Doing that in MAC not works. For the HEX editor, I've using HEX friend.
@Amarindaz4 жыл бұрын
If that's the case please use the online service to unlock instantly bit.ly/crack-password
@vijaya9968 жыл бұрын
its works bro thanks u very much apprisated
@Amarindaz8 жыл бұрын
glad to hear :)
@NguyenDuy-jt8gb6 жыл бұрын
thanks for sharing. it's worked very well
@Amarindaz6 жыл бұрын
Thank you. Subscribe and stay tuned :)
@mhirekafumigene63896 жыл бұрын
God bless you my bro ....
@sujoydutta25985 жыл бұрын
Its giving "Unexpected error (40230)" for all Modules ; please suggest
@PathanSohel4 жыл бұрын
I have .xls file and converting it to .zip file, it is not further get extracted
@Amarindaz4 жыл бұрын
Which means your workbook is protected.Please use the online service to unlock instantly bit.ly/crack-password
@akshaybansal10915 жыл бұрын
What is the alternate for Hexa editor ?
@kuldeepmittapally6 жыл бұрын
I need to unlock a file, can i share it with you for your help...?