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

  Рет қаралды 398,441

Amarindaz

Amarindaz

Күн бұрын

Пікірлер: 254
@DineshKumar-lq2ck
@DineshKumar-lq2ck 4 жыл бұрын
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
@Amarindaz
@Amarindaz 4 жыл бұрын
Glad it helped!
@wealthy_you
@wealthy_you 3 жыл бұрын
Works in 2021 toooo.. thank a lot sir. You have saved me
@primuseng5822
@primuseng5822 5 жыл бұрын
Thank you...I saved one old project I did and forgot password! You are a genius!!
@moharsingh4953
@moharsingh4953 3 жыл бұрын
My file is lock plz help
@MT4LYF
@MT4LYF 5 жыл бұрын
first time i misunderstood putting a X at DPB. once i did 2nd time and used DPX it worked. thank you very much
@macspt4383
@macspt4383 4 жыл бұрын
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!!!
@maciejbeker6212
@maciejbeker6212 4 жыл бұрын
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
@anandar140
@anandar140 7 жыл бұрын
My boss has created code and forgot password now i unlocked VBA by your codes Thank you...
@Amarindaz
@Amarindaz 7 жыл бұрын
+Ananda R Glad to hear
@nickiawalker645
@nickiawalker645 4 жыл бұрын
This video was king. And helped me unlock a file a seller I paid tried to lock.
@neerajmalik5979
@neerajmalik5979 6 жыл бұрын
Thanks for making this video because this video really helped me to unlock my old VBA protected file. Thanks again.
@Amarindaz
@Amarindaz 6 жыл бұрын
Glad to hear
@kashmiri4209
@kashmiri4209 4 жыл бұрын
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
@kevindsilva1344
@kevindsilva1344 6 жыл бұрын
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?
@Ciera52
@Ciera52 7 жыл бұрын
Thank you. I tried at least 10 different ways to bypass the password code and yours is the only one that worked.
@karolispulokas1364
@karolispulokas1364 6 жыл бұрын
Works like a charm on Excel 2013. Coffee bought. Thanks a lot
@Amarindaz
@Amarindaz 6 жыл бұрын
Glad to hear :)
@Davises12
@Davises12 6 жыл бұрын
hepl me unlock uloz.to/!MLvVpREbHJyB/sluzebni-cesty-xls?_fid=vqpk????
@IkhwanReza
@IkhwanReza 5 жыл бұрын
can't find DPB using MAC, hex friend editor, please help
@123jalluri
@123jalluri 4 жыл бұрын
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
@Amarindaz
@Amarindaz 4 жыл бұрын
Not sure what went wrong with your case. I suggest to use online service to unlock instantly bit.ly/unprotect-excel-Workbook
@CR-wk4qt
@CR-wk4qt 5 жыл бұрын
Followed your steps EXACTLY, and when I am at 5:34, I get a prompt in Excel about "Dynamic Data Exchange"?
@karnadharboro
@karnadharboro 7 жыл бұрын
file corrupt not opening and no xl folder in it
@ThomasJr
@ThomasJr 5 ай бұрын
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.
@amenell3
@amenell3 8 жыл бұрын
When I try to open the .xls file, XL tells me that it can't because the file is corrupt.
@Dhannraj
@Dhannraj 2 жыл бұрын
Wonderful. Thank you for putting up this video. Would you be having something similar for PowerPoint Presentations?
@9487nupur
@9487nupur 2 жыл бұрын
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
@joep4life
@joep4life 2 жыл бұрын
I have the same problem. Did you manage to solve it?
@abeljeremiah99
@abeljeremiah99 4 жыл бұрын
Thank Master It's Very very to rescue my problem And Done. Thx again.
@g4m4de
@g4m4de 5 жыл бұрын
Works like a charm! Amazing. Thank you!!!
@luamoura985
@luamoura985 4 жыл бұрын
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.
@jetli4557
@jetli4557 5 жыл бұрын
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?
@FiniteTurtles
@FiniteTurtles 4 жыл бұрын
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
@blukido5700
@blukido5700 4 жыл бұрын
Thanks man for your video. It did helped me. Already subcribed and bell all :D
@moesadr3342
@moesadr3342 4 жыл бұрын
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?
@Amarindaz
@Amarindaz 4 жыл бұрын
In this case I suggest online excel password remover bit.ly/unprotect-excel-Workbook
@thearchibaldtuttle
@thearchibaldtuttle 7 жыл бұрын
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.
@Jwalker0075
@Jwalker0075 2 жыл бұрын
Hi, I have lock the VBA files but cannot unlock to see my VBA sheet. Can you help me ?
@karthikannam3588
@karthikannam3588 7 жыл бұрын
Hi,Xl folder is missing when i zipped the file.Could you help me out?
@OmarAhmed-cm3mv
@OmarAhmed-cm3mv Жыл бұрын
Thank you so much it's simple and effective.
@MultiAssassin121
@MultiAssassin121 8 жыл бұрын
Daaaaam Worked like a charm. Thank you very much!
@aNDy-qh1em
@aNDy-qh1em Жыл бұрын
Thank you so much sir. You have made my day!
@vladimir193
@vladimir193 3 жыл бұрын
Amazing! Still works! :) Thanks a lot
@LearnShine
@LearnShine 6 жыл бұрын
i couldnt find vbaproject.bin file in my case, how can i proceed
@paperso696
@paperso696 6 жыл бұрын
nice, thanks ! fyi, worked as well opening with notepad++ rather than HEX editor (excel 2013)
@dhruvtrivedi9231
@dhruvtrivedi9231 4 жыл бұрын
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.
@frankie3005
@frankie3005 5 жыл бұрын
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
@Amarindaz
@Amarindaz 5 жыл бұрын
You're welcome. Please checkout kzbin.info/www/bejne/rYuonoCmetBjerc for unlocking sheets
@กตติโชติลดาวดี
@กตติโชติลดาวดี 3 жыл бұрын
How to remove old version ".xls"
@selvarasan.v7246
@selvarasan.v7246 2 жыл бұрын
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
@right2money
@right2money 4 жыл бұрын
Simply Wow..!! loved it..!!
@vikram9966
@vikram9966 4 жыл бұрын
Yes it works for me.Thank u so much
@MrChandrasekharreddy
@MrChandrasekharreddy 7 жыл бұрын
Thank you Amar!! This is really worked
@Baiaaa96
@Baiaaa96 3 жыл бұрын
Excellent job. I hope it will never get deleted :D
@RAVISHARMA-hn1iv
@RAVISHARMA-hn1iv 4 жыл бұрын
but it is showing below error and removing vba part. please guide................ Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
@Amarindaz
@Amarindaz 4 жыл бұрын
Please use the online service to unlock VBA password instantly bit.ly/crack-password
@lamvinhha
@lamvinhha 6 жыл бұрын
I tried, but at step find DPB in Hex it show mess "can't find DPB". How can i do? Please help!
@thcarm
@thcarm 7 жыл бұрын
Thanks very much mate. I wonder how someone first discovered this
@piyushkataria49
@piyushkataria49 7 жыл бұрын
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-zx3bm
@GulshanKumar-zx3bm 6 жыл бұрын
Beautifully explained and worked very well. Very helpfull
@nehashroff2990
@nehashroff2990 5 жыл бұрын
Hi In my macro step6 is not visible, It is also locked how to proceed further in that case
@Amarindaz
@Amarindaz 5 жыл бұрын
Please use the online service to unlock instantly bit.ly/crack-password
@alphaeriortiz4657
@alphaeriortiz4657 4 жыл бұрын
Thank you sooooo much, you are awesome! totally solved my problem.
@ramzikhouri
@ramzikhouri 5 жыл бұрын
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.)
@krish2519
@krish2519 7 жыл бұрын
It's was amazing... thanks... Amar :)
@vineetverma9178
@vineetverma9178 6 жыл бұрын
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?
@aylanmoriarty7893
@aylanmoriarty7893 2 жыл бұрын
hello, did you find a solution for that! I have the same problem too now :/
@darshanalanka7456
@darshanalanka7456 7 жыл бұрын
Amazing Work bro.... Thanks for this
@Amarindaz
@Amarindaz 7 жыл бұрын
+Darshana Lanka Thank you!
@anurenjdas7353
@anurenjdas7353 5 жыл бұрын
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_streets
@bratislava_streets 3 жыл бұрын
so simple and yet so much helpful, thanks so much
@alokghosh9311
@alokghosh9311 5 жыл бұрын
vbaProject.bin shows as vlc media file type (99kb). Hex Editor tool is installed...
@incor3480
@incor3480 2 жыл бұрын
When i try to save the Hex editor it says "this file is set to read only. Try again with a different file name".
@llalbwansingh9362
@llalbwansingh9362 2 жыл бұрын
I have problem with Excel Workbook Password Removal or Recovery to Open. Not excel Sheet password...! Can you help ...?
@SimX9000
@SimX9000 3 жыл бұрын
I love you. Working Office 365 2021. Crazy!
@audiobooksbyami6360
@audiobooksbyami6360 3 жыл бұрын
Thanks so much! It's totally worked!
@anthonymartin3579
@anthonymartin3579 7 жыл бұрын
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.
@psolankurkar
@psolankurkar 2 жыл бұрын
Excellent Video. It worked for me
@sureshghori3081
@sureshghori3081 5 жыл бұрын
THANKS A LOT DEAR....KEEP WORKING LIKE THIS....
@kingimad6243
@kingimad6243 6 жыл бұрын
Pleasr sir i'm looking for a method to remove VBA protection when the macro is disabled from viewing
@yogeshnirmal5416
@yogeshnirmal5416 5 жыл бұрын
Thanks a lot.. it worked 👍👍
@Achinthac
@Achinthac 5 жыл бұрын
100% worked for me, thank you very much...
@KhaledYosrykhaled
@KhaledYosrykhaled 7 жыл бұрын
when i finally open the VB after completing all the steps , it says the VB project is unviewable ,, what to do ?
@esjay12
@esjay12 4 жыл бұрын
Legend. works in 2020.
@DetailsByVJ
@DetailsByVJ 7 жыл бұрын
This is not working in 2016 version. If any know to resolve this please let know.
@nizarkhorchani8855
@nizarkhorchani8855 6 жыл бұрын
download hexeditor and repeat the same actions in the video :)
@murilospineli2241
@murilospineli2241 6 жыл бұрын
@@nizarkhorchani8855 Don't work!
@nizarkhorchani8855
@nizarkhorchani8855 6 жыл бұрын
@@murilospineli2241 yes men it s working just download hexaediteur and do the same steps
@murilospineli2241
@murilospineli2241 6 жыл бұрын
@@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)
@nizarkhorchani8855
@nizarkhorchani8855 6 жыл бұрын
@@murilospineli2241 sorry Murilo the workbook is save it as Excel binary workbook (.xlsb) without macros so i cannot give you a hand :(
@MsBuddy2000
@MsBuddy2000 5 жыл бұрын
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.
@owenprice5647
@owenprice5647 3 жыл бұрын
"DPB". not "DPP".
@kuldeepmittapally
@kuldeepmittapally 6 жыл бұрын
Sir, I have sent you a message through your website regarding unlocking an xlsb Macro file, still waiting for your response...
@krishikaramaswamy4681
@krishikaramaswamy4681 6 жыл бұрын
This was very helpful. Thank you :)
@aischacelik8161
@aischacelik8161 3 жыл бұрын
Thank you very much. It is working!!!
@dyer10
@dyer10 4 жыл бұрын
Anyway to do this on a docm file instead of an xlsm? Cheers.
@thiagos.a.5819
@thiagos.a.5819 7 жыл бұрын
Doesn't work. "Erro opening file vbaproject.bin".
@KebbyLL
@KebbyLL 4 жыл бұрын
I was able to get to VBA properties and be able to view all the sheet. But there is not password in module 1
@ashiqmir2717
@ashiqmir2717 3 жыл бұрын
When i extracted there is no XL folder infact there are only 2 folders and 1 file.....
@luisahumada6081
@luisahumada6081 3 жыл бұрын
It worked dude!!! you save my life... heheheheh... tks
@muciobatista10
@muciobatista10 5 жыл бұрын
Hi Amarindaz, your tool unlock sheets and vba modules?
@shailendravishwakarma9335
@shailendravishwakarma9335 2 жыл бұрын
Thanks! It really works 👍
@raftarrr7564
@raftarrr7564 5 жыл бұрын
XLs file is not creating while extracted from win rar zip
@crfly1on
@crfly1on 7 жыл бұрын
When I get to the VBA screen, I keep getting "Project is unviewable". Can you help?
@miroslavtriebel8126
@miroslavtriebel8126 5 жыл бұрын
Thanks for the video, you saved me. All good to you
@adetoyeseakanbi9768
@adetoyeseakanbi9768 3 жыл бұрын
After changing the file name, right clicking is not giving extract all option
@vefeye
@vefeye 5 жыл бұрын
doesn't worked on ms 19 excel,any idea?
@Amarindaz
@Amarindaz 5 жыл бұрын
Please use the online service to unlock instantly bit.ly/crack-password
@bezuchof
@bezuchof 6 жыл бұрын
Thanks a million! Very clear and it works, this is great.
@Amarindaz
@Amarindaz 6 жыл бұрын
You're welcome :)
@bpoojajain9408
@bpoojajain9408 5 жыл бұрын
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!!
@chinhphan8127
@chinhphan8127 5 жыл бұрын
Link you
@LeonardoSanchez-ig2pm
@LeonardoSanchez-ig2pm 4 жыл бұрын
Doing that in MAC not works. For the HEX editor, I've using HEX friend.
@Amarindaz
@Amarindaz 4 жыл бұрын
If that's the case please use the online service to unlock instantly bit.ly/crack-password
@vijaya996
@vijaya996 8 жыл бұрын
its works bro thanks u very much apprisated
@Amarindaz
@Amarindaz 8 жыл бұрын
glad to hear :)
@NguyenDuy-jt8gb
@NguyenDuy-jt8gb 6 жыл бұрын
thanks for sharing. it's worked very well
@Amarindaz
@Amarindaz 6 жыл бұрын
Thank you. Subscribe and stay tuned :)
@mhirekafumigene6389
@mhirekafumigene6389 6 жыл бұрын
God bless you my bro ....
@sujoydutta2598
@sujoydutta2598 5 жыл бұрын
Its giving "Unexpected error (40230)" for all Modules ; please suggest
@PathanSohel
@PathanSohel 4 жыл бұрын
I have .xls file and converting it to .zip file, it is not further get extracted
@Amarindaz
@Amarindaz 4 жыл бұрын
Which means your workbook is protected.Please use the online service to unlock instantly bit.ly/crack-password
@akshaybansal1091
@akshaybansal1091 5 жыл бұрын
What is the alternate for Hexa editor ?
@kuldeepmittapally
@kuldeepmittapally 6 жыл бұрын
I need to unlock a file, can i share it with you for your help...?
@nemilshah1945
@nemilshah1945 6 жыл бұрын
It not working on xlsb file ..,????
@jozefbubliak879
@jozefbubliak879 8 жыл бұрын
Its works. Thanks for help
🔓 Remove VBA Password in Seconds in Excel (2 Easy Ways)
8:58
小丑女COCO的审判。#天使 #小丑 #超人不会飞
00:53
超人不会飞
Рет қаралды 16 МЛН
EASILY UNLOCK Protected Excel Sheets WITHOUT Password
5:40
Leila Gharani
Рет қаралды 2,1 МЛН
How to Create a Data Entry Form in Excel
34:30
Excel Macro Mastery
Рет қаралды 308 М.
Новый год 2025 на ТНТ "ComedyVision!" @ComedyClubRussia
1:16:27