After looking at numerous 'How to' videos this is the first one that really work to remove sheet/workbook protection. Very clear and straightforward video.
@MyOnlineTrainingHub
11 ай бұрын
Glad it helped!
@EliotPowell
Жыл бұрын
incredibly helpful. I have seen other videos explaining these techniques, but yours is the clearest and simplest to follow. well done!
@MyOnlineTrainingHub
Жыл бұрын
Awesome, thank you, Eliot!
@caongoc1204
Жыл бұрын
@@MyOnlineTrainingHub Can you help me remove excel password? I forgot pass
@christopherpanford7584
Жыл бұрын
This was super helpful. My accountant left a couple of months ago and when I recruited a new one, we realised that our entire books were protected. We have been struggling to get it unprotected for weeks, and within 10mins your video has done the magic. Thank you.
@MyOnlineTrainingHub
Жыл бұрын
Wonderful to hear!
@marcelolaguna2012
Жыл бұрын
Thank you very much! I always forget my passwords. I love your channel, your didactics and affection in passing on knowledge are incredible.😀
@MyOnlineTrainingHub
Жыл бұрын
So nice of you to say, Marcelo!
@shiffamohammed5818
Жыл бұрын
Many thanks Mynda, for sharing a video that clearly explains password unprotecting under various situations in excel.
@MyOnlineTrainingHub
Жыл бұрын
My pleasure, Shiffa!
@waynegill2613
7 ай бұрын
Such a simple video to follow but it saved me so much work! Thank you!
@MyOnlineTrainingHub
7 ай бұрын
Awesome to hear 😊
@darrylmorgan
Жыл бұрын
Hi Mynda!Super Helpful And Clear Explanations...Thank You :)
@MyOnlineTrainingHub
Жыл бұрын
Great to hear, Darryl!
@ekkiwurm7874
Жыл бұрын
Super helpful video. Thanks a million for sharing, Mynda.
@MyOnlineTrainingHub
Жыл бұрын
You are so welcome, Ekki!
@notesfromleisa-land
Жыл бұрын
I recently had to use the zip file technique to fix a workbook that would not save as I was getting corrupted and repairs so extensive msgs that make you weep as tons of time in the workbook creation. Removing a bin file using the zip technique saved the day. Here is yet another way to slice and dice. As always great vid content perfectly presented
@MyOnlineTrainingHub
Жыл бұрын
Thanks so much 🙏
@MlguelM
Жыл бұрын
Wow Mynda! Nice usefull tips! Thanks a lot!
@MyOnlineTrainingHub
Жыл бұрын
You're so welcome!
@tokinabo
11 ай бұрын
As always, great tips! Thanks a lot, Mynda 🙂
@MyOnlineTrainingHub
11 ай бұрын
Glad you like them! 🙏
@terrycathie115
4 ай бұрын
The zip file worked for me and I can’t thank you enough. A great deal of work had gone into the spreadsheet and I was pretty upset with myself. Thanks again 👍😊
@MyOnlineTrainingHub
4 ай бұрын
So pleased to hear that!
@bobmoorehead8553
Жыл бұрын
Excellent as always! Thank you!
@MyOnlineTrainingHub
Жыл бұрын
Thanks so much, Bob!
@mannycorrea5896
Жыл бұрын
Incredible video. Thank you so much!
@MyOnlineTrainingHub
Жыл бұрын
Glad you liked it!
@chrism9037
Жыл бұрын
Super helpful, thanks Mynda!
@MyOnlineTrainingHub
Жыл бұрын
Cheers, Chris!
@will5470
Жыл бұрын
thank you for this resource! saved me a few hours of recreating a sales document.
@MyOnlineTrainingHub
Жыл бұрын
Glad I could help!
@arjungovindan178
Жыл бұрын
Superb Mynda, explained very clearly.... Thanks a lot ❤
@MyOnlineTrainingHub
Жыл бұрын
Glad you liked it
@jawadahmadehssan6251
Жыл бұрын
Thanks Mynda for the information.
@MyOnlineTrainingHub
Жыл бұрын
You are so welcome!
@MsChampohsan
8 ай бұрын
Wonderful tips! Its kinda suffering when I forgot the password that I have set. Thank you! Incredible video ever!
@MyOnlineTrainingHub
8 ай бұрын
Glad you liked it 🙏
@Liz-u7o
Жыл бұрын
AMAZING! You saved me a great deal! Thank you, subscribing!
@MyOnlineTrainingHub
Жыл бұрын
So pleased I could help!
@noahmayorestor8459
11 ай бұрын
Wow, its really great to find this video that makes me back to my work. Thank you.
@MyOnlineTrainingHub
11 ай бұрын
Glad it was helpful!
@powerb_i
Жыл бұрын
Great video and well explained. Thank you.
@MyOnlineTrainingHub
Жыл бұрын
Glad you enjoyed it!
@sudds50
Жыл бұрын
This is brilliant!! Thank you!!
@MyOnlineTrainingHub
Жыл бұрын
Glad you liked it!
@Vandalfoe
Жыл бұрын
Good stuff as usual. I agree this isn't super-spy level protection, but in my opinion it does the job of preventing users (who don't Excel) from typing numbers over your formulas because they're not using the spreadsheet properly. 👍
@MyOnlineTrainingHub
Жыл бұрын
Yes, exactly that 😊
@garygarland9366
6 ай бұрын
Worked a treat - THANK YOU!
@MyOnlineTrainingHub
6 ай бұрын
Awesome to hear 👍
@adammaamoun1
8 ай бұрын
Thank you, it helped a lot. It is important to save a copy of the xml file we are editing because I messed up multiple times since I was not using Notepad ++ and didn't know when the workbookprotection and sheetprotection statements ended. Yes, your instructions were used for legal process to unprotect an excel file I forgot its password.
@MyOnlineTrainingHub
8 ай бұрын
Great to hear!
@user-qr8oe2fs5h
Жыл бұрын
God bless you Madam. A life saver
@MyOnlineTrainingHub
Жыл бұрын
Glad it was helpful!
@traciedwards7449
26 күн бұрын
LIFE SAVER!!!!! Yes I'm using my new skills for the greater good 😀 Thank you so much for the tutorial for this!!!
@MyOnlineTrainingHub
26 күн бұрын
Awesome to hear!
@rhonalkhairul3969
Жыл бұрын
Very nice info, thank you for sharing.
@MyOnlineTrainingHub
Жыл бұрын
Glad it was helpful!
@odel_leal
Жыл бұрын
Thank you for your video. It’s interesting.
@MyOnlineTrainingHub
Жыл бұрын
My pleasure 👍
@eslammaher8696
Жыл бұрын
Thank you very much,really amazing 😍
@MyOnlineTrainingHub
Жыл бұрын
I'm glad you liked it 🙏
@aurelieneveu9595
Жыл бұрын
Big thank you !
@MyOnlineTrainingHub
Жыл бұрын
You're welcome!
@Johnmel1993
Жыл бұрын
Very helpful. Thank you
@MyOnlineTrainingHub
Жыл бұрын
Great to hear!
@HimeshDharmameher
Жыл бұрын
Excellent stuff Mynda
@MyOnlineTrainingHub
Жыл бұрын
Thank you!
@vijaykumar140292
22 күн бұрын
Thank you, it was very helpful and saved me a lot of time.
@MyOnlineTrainingHub
22 күн бұрын
Great to hear!
@matingholizade647
Жыл бұрын
incredibly helpful
@MyOnlineTrainingHub
Жыл бұрын
Great to hear 🙏
@yuvarajarajasekaran7997
10 ай бұрын
Thank you very much your guidance. keep it up.
@MyOnlineTrainingHub
10 ай бұрын
Thank you, I will 😊
@nunocorreia5570
Жыл бұрын
Very useful, thanks
@MyOnlineTrainingHub
Жыл бұрын
Glad to hear that!
@omerabdu9093
Жыл бұрын
Great Helpful tutorial
@MyOnlineTrainingHub
Жыл бұрын
Glad you think so!
@RT-up6ml
Жыл бұрын
Thank you I managed to use it for one of my old file I forgot password. User friendly
@MyOnlineTrainingHub
Жыл бұрын
Glad it helped!
@user-mu7te7uz8n
10 ай бұрын
You're genius. It works!
@MyOnlineTrainingHub
10 ай бұрын
Glad it helped 😊
@williamlongbottom5494
7 ай бұрын
Saved me hours. Thankyou
@MyOnlineTrainingHub
7 ай бұрын
Glad I could help!
@yashkatariya7922
Жыл бұрын
thank you so much for the help.
@MyOnlineTrainingHub
Жыл бұрын
You're welcome!
@aamir6666
Жыл бұрын
Amazing. thank you.
@MyOnlineTrainingHub
Жыл бұрын
Glad it was helpful!
@basitalisyed9445
Жыл бұрын
Very helpful tutorial... Good.
@MyOnlineTrainingHub
Жыл бұрын
Glad you think so!
@EduardKorkia
Жыл бұрын
Thank you! 🤙
@MyOnlineTrainingHub
Жыл бұрын
My pleasure, Eduard!
@baboomka
Жыл бұрын
thanks
@sadeemalolayan1568
19 күн бұрын
Thank you for your helping
@MyOnlineTrainingHub
19 күн бұрын
My pleasure!
@mariamafshar9210
Жыл бұрын
It is working, bunch of thanks :)
@MyOnlineTrainingHub
Жыл бұрын
Welcome 👍
@jhoanramiso1168
6 күн бұрын
Thank you so much!
@MyOnlineTrainingHub
6 күн бұрын
You're welcome!
@daniellazylen5350
Жыл бұрын
that's awesome! thanks!
@MyOnlineTrainingHub
Жыл бұрын
Glad it was helpful!
@meicromini
6 ай бұрын
You absolute legend.❤
@MyOnlineTrainingHub
5 ай бұрын
Glad I could help 😊
@navychhun4645
Жыл бұрын
thank you so much!
@MyOnlineTrainingHub
Жыл бұрын
You're welcome!
@syedshas7105
Жыл бұрын
Thank you so much
@MyOnlineTrainingHub
Жыл бұрын
You're most welcome 😊
@heinzthedutch
14 күн бұрын
"luckily" it is that easy... just succesfully removed one - thanks Mynda
@MyOnlineTrainingHub
14 күн бұрын
Glad it helped!
@filippoxodo3354
Жыл бұрын
thank you very very much
@MyOnlineTrainingHub
Жыл бұрын
My pleasure!
@FishFinderHeroes
10 ай бұрын
very helptull video, thanks a lot mam, take ❤
@MyOnlineTrainingHub
10 ай бұрын
Most welcome 😊
@AhmedElsayed-ur8hv
Жыл бұрын
Very nice it was help me thank you very muchs
@MyOnlineTrainingHub
Жыл бұрын
Most welcome 😊
@alejos1
Жыл бұрын
wow - Thank you
@MyOnlineTrainingHub
Жыл бұрын
You're welcome!
@eyalbaruch7874
11 ай бұрын
amazing how simple it is :-)
@MyOnlineTrainingHub
11 ай бұрын
Glad you think so!
@cooljoker2027
Жыл бұрын
thank you and i looove you
@MyOnlineTrainingHub
Жыл бұрын
My pleasure 😊
@huyne_info
Жыл бұрын
Thank you so much
@MyOnlineTrainingHub
Жыл бұрын
You're welcome!
@evo.gaming255
5 ай бұрын
superb video
@MyOnlineTrainingHub
5 ай бұрын
Thank you so much 😀
@prosenjitpaul8220
Жыл бұрын
Wow... You are awesome 🙂
@MyOnlineTrainingHub
Жыл бұрын
Thank you so much 😀
@emmapilex
Ай бұрын
Excellent
@MyOnlineTrainingHub
Ай бұрын
Glad it was helpful 😊
@boyapatirakesh6913
4 ай бұрын
it's super , thx u
@MyOnlineTrainingHub
4 ай бұрын
Welcome 😊
@elsalorenzana6795
Жыл бұрын
You are the best! I follow you since a year ago and I find your tutorials very helpful. Thanks :)
@MyOnlineTrainingHub
Жыл бұрын
Awesome to hear, thank you!
@MrPaulHausser
Жыл бұрын
Thx 😊
@MyOnlineTrainingHub
Жыл бұрын
My pleasure!
@joseriosperic8676
Ай бұрын
Gracias !!
@MyOnlineTrainingHub
Ай бұрын
Pleasure 🙂
@jesus.moreno
Жыл бұрын
wouuuuuuuuuu you are the best .... you got a susbriber to your channel ... muchas gracias!!!
@MyOnlineTrainingHub
Жыл бұрын
Thanks so much!
@emile8147
Жыл бұрын
thanks for the tricks ! for the sheet protection level (if you can select all the cells), you can just select all the cells, copy, create a new sheet, paste on A1. the new sheet is not protected there's too some VBA code to unprotect the sheet, probably too to unprotect workbook
@MyOnlineTrainingHub
Жыл бұрын
Yes, it they've allowed cell selection, then copying and pasting is an option. It all depends how complex the file is as to how successful that would be. The VBA unprotection code was required for .xls file types, but with .xlsx we can simply unzip the file and locate the settings.
@ashu17981
5 ай бұрын
Thank you so much for the wonderful information. I am able to crack the password. Protected to Un-Protected
@MyOnlineTrainingHub
5 ай бұрын
Glad I could help 😊
@rajeshchawda9449
Жыл бұрын
Superb! This is very Helpful. Thanks for sharing. Can we remove the password of an Excel Macro (Dot xlsm) file in the same manner?
@MyOnlineTrainingHub
Жыл бұрын
Yes, pretty much.
@enzym2004
Жыл бұрын
Saved my day =)
@enzym2004
Жыл бұрын
But the file has to be unencrypted to to these tricks.
@MyOnlineTrainingHub
Жыл бұрын
Yes, if the password is at the file level, then you're out of luck, as explained in the last example.
@nadermounir8228
Жыл бұрын
Thank u for this video 📹. How did u open the XML in one note ?
@MyOnlineTrainingHub
Жыл бұрын
I'm using Notepad ++, not OneNote.
@thabangsimelane7730
Жыл бұрын
Wow!
@MyOnlineTrainingHub
Жыл бұрын
Glad you liked it 🙏
@bro.jamessoc5830
Жыл бұрын
Hello Ma'am, thank you for taking the time making this video. I'm getting a prompt when trying to open the zip. "copy.zip is invalid".
@bro.jamessoc5830
10 ай бұрын
@ansicin6883 no. This has been resolved. Luckily the user found the pw.
@vinicsurveying
Жыл бұрын
Great explanation as usual! Do you know if there is a similar way to remove the password for opening Visual Basic?
@byronstutorialspage2134
Жыл бұрын
there is... using VBA Code... its much easier.
@vinicsurveying
Жыл бұрын
@@byronstutorialspage2134 thanks for confirming that. I assume that the VBA code must be run from another spreadsheet in that case? I was hoping that you could make it so that the VBA code is not accessible.
@_S.H_
12 күн бұрын
I was hoping for any tips on removing or replacing the password of the older xls format.
@MyOnlineTrainingHub
11 күн бұрын
Hmm, not that I can point you to, sorry.
@maheshnaik8388
Жыл бұрын
Good ....
@MyOnlineTrainingHub
Жыл бұрын
Thanks 😊
@Daithai96
Жыл бұрын
I've always written macros that apply that protection as soon as the workbooks open. So, you could use these techniques, but unless you could also hack the VBA code, it wouldn't work on the useable file. But, still a very interesting video
@MyOnlineTrainingHub
Жыл бұрын
Nice trick, Dave! You can remove VBA protection with a similar technique to editing the zip file.
@Daithai96
Жыл бұрын
@@MyOnlineTrainingHub Yeah, you can indeed. I wouldn't try to write a security app using VBA, but the number of people that are able to hack the VBA code is relatively small in my experience.
@IvanCortinas_ES
Жыл бұрын
Without having to eliminate the entire sheetProtection clause, it is also possible to change the sheet, objects and scenarios sections (within sheetProtection) from 1 to 0 within said clause and continue with the process.
@MyOnlineTrainingHub
Жыл бұрын
Nice tip, cheers, Ivan!
@teoxengineer
Жыл бұрын
Great tips Mynda, thank you! How can we break the VBA password to enter VBA code window? Do you know it? Thank you
@MyOnlineTrainingHub
Жыл бұрын
Hi Emre, it's similar and is explained here: www.devhut.net/excel-unlocking-an-excel-vba-project/
@yahyaalramadan4665
Жыл бұрын
Thank you for the interesting video. Are Excel VBA protected projects as easy to unprotect?
@matroosoft4589
Жыл бұрын
Was wondering this, too!
@MyOnlineTrainingHub
Жыл бұрын
Looks like it is: www.devhut.net/excel-unlocking-an-excel-vba-project/
@gonzuic
Жыл бұрын
That’s awesome ❗️Mynda, what do you recomend to learn, Visual Basic o Java Script❓Thanks
@MyOnlineTrainingHub
Жыл бұрын
Ooh, good question. I'd probably go with JavaScript as this will have more application going forward.
@gonzuic
Жыл бұрын
@@MyOnlineTrainingHub Do you have some course about this❓Thanks
@wah13
Жыл бұрын
Thank you for the video, able to unprotect the excel sheet. Better than Chatgpt at the moment😂
@MyOnlineTrainingHub
Жыл бұрын
😁 glad I could help!
@wladimirtanasovichi5542
7 ай бұрын
You have a brilhant brain!
@MyOnlineTrainingHub
7 ай бұрын
So glad my video was helpful 😊
@Earth-360
Жыл бұрын
can not thank you enough!
@MyOnlineTrainingHub
Жыл бұрын
Pleasure 😊
@brandonmays8604
Жыл бұрын
Pro Tip for Mac users as well (because I couldn't do this) but I found another way! change the file extension to .csv, it will open with Numbers and remove all passwords!
@MyOnlineTrainingHub
Жыл бұрын
Thanks for sharing, Brandon!
@Dany-ns6hg
Жыл бұрын
Good one and very helpful, I remember this trick long back someone shared with me but it helped me to recollect. Do you have any trick to unlock VBA editor password because I lock most of my files for VBA editor so that user should not change code?
@MyOnlineTrainingHub
Жыл бұрын
Thanks, Dany! I haven't got a VBA example, but I'll add it to my To-Do list!
@byronstutorialspage2134
Жыл бұрын
@@MyOnlineTrainingHub I have VBA Code for breaking the VBA Editor Protection.
@azizaalbakr1757
Жыл бұрын
👌
@paullindod
2 ай бұрын
Thanks for the great video. Is it possible to check the password in the XML tag?
@MyOnlineTrainingHub
2 ай бұрын
No, you can't find the password, the best you can do is remove it.
@paullindod
2 ай бұрын
@@MyOnlineTrainingHub Thanks for the reply.
@szymongrabarczyk3561
Жыл бұрын
You actually can unzip protected file, open worksheets and some info is visible but most is encrypted.
@hhasanat
9 ай бұрын
Thank you for you really nice page and useful videos I tried this procedure at excel 365 but it did work... Could you check that for me please?
@MyOnlineTrainingHub
9 ай бұрын
Please post your question and sample Excel file on our forum where someone can help you further: www.myonlinetraininghub.com/excel-forum
@chaitanyapatwari
Жыл бұрын
Thanks, Mynda. Is it also possible to view the password using this method so that we can unlock the sheet instead of removing protection?
@MyOnlineTrainingHub
Жыл бұрын
Not that I'm aware of.
@goodone05004
Жыл бұрын
So if you put a password to open the file and a different password for the sheets, then people can't remove either of those passwords by the methods you showed right? Your videos are way better than the other excel channels btw. Thank you for the amazing work
@MyOnlineTrainingHub
Жыл бұрын
Thank you 🙏 yes, if you password protect the file to open it then that password can’t be removed using these techniques, therefore the password for the sheets is also protected.
@Vandalfoe
Жыл бұрын
In fact, the passwords needn't even be different; they'll never get into the zip file anyway. 👍
@ericc.3524
Жыл бұрын
Hello Mynda and thank you for the great video. After I copy and rename the file extension to .zip, it won't extract all and I get a window prompt indicating the compressed file is empty. The file size in properties appears the same as the original worksheet, however. Kindly advise. Many thanks.
@MyOnlineTrainingHub
Жыл бұрын
Sounds like you have a file that falls into the last scenario I covered. i.e. the password is at the file level.
@ericc.3524
Жыл бұрын
@@MyOnlineTrainingHub Thank you!
@byronstutorialspage2134
Жыл бұрын
If anyone is interested I have the VBA code to break sheet protection and VBA Editor protection. ... its much much easier. Just save them both to your Personal Excel file and tey will always be available to you. all you have to do is run the code. Problems solved!
@christoslefkimiotis9889
Жыл бұрын
Great video and I have used the trick (sheet level) a couple of times. Is there any way to retrieve the actual password?
@MyOnlineTrainingHub
Жыл бұрын
I don't think so, Christos.
@christoslefkimiotis9889
Жыл бұрын
@@MyOnlineTrainingHub Thank you very much for the reply. There was an addin that could unprotect sheets and you could see the lenght of the password but not the actual password. So more or less there is no safe way tor your data and files.Thanks
@KarenGonzalez-cf4jk
Жыл бұрын
Hi! I'm also having problems by trying this method. Whenever I'm looking for the word "protected" or some variant (the whole workbook is protected) it isn't on the code anymore. Is it possible they've updated the security? I would really appreciate your thoughts on this! I love your videos!
@MyOnlineTrainingHub
Жыл бұрын
If the file is protected at the File Open step, then you're dealing with the last example covered in the video, in which case you can't use the zip file technique.
Пікірлер: 483