✅ Download Practice Workbook: »»
Remove Excel sheet protection and add it back again…..all without even knowing the password. In this video I’ll show you 3 ways to crack password protection on Excel sheets and re-protect them afterwards.
👨🏫 Remove On-Screen Tutor: »»
======================================================================================
🕑 Video Timings and Methods Used:
00:00 Overview of Methods
00:50 Method 1: Get Lucky – find it within existing VBA code
02:50 Method 2: Remove with a VBA macro – can’t restore the password after
06:44 Method 3: Hack the File Code – Fastest and most likely to work, but most advanced
======================================================================================
You will learn how to unprotect an Excel sheet without knowing the password in 3 different ways with this video. You can remove an Excel password without software as long as the file is not encrypted. Learning how to unprotect an Excel sheet can be as straight forward as using the toolbar command to unlock protected Excel sheets without passwords. If there is a password, you will want an Excel password remover- without any application – in order to crack Excel sheets. I will show you 3 ways how to unprotect Excel sheets without the password and thereby remove Excel password protection. When you see how to unlock protected Excel sheets without the password you can regain control of spreadsheets with forgotten Excel passwords. You do not need an Excel password cracker to unprotect Excel cells without the password, because when you remove Excel protection without software you will unlock the Excel spreadsheet, unprotect the sheet in Excel and unlock cells all at once.
I show you how to unprotect excel sheets in 3 ways. It’s the same as having an excel password remover- without any application. Yes, remove excel password without software and unprotect sheet. When you know how to unprotect excel sheet without knowing password you can crack excel sheets, remove excel protection without software, and unlock protected excel sheets without password. This video shows how to unprotect excel sheet in windows 10 but works exactly the same in all versions of windows. Unlock your excel spreadsheet now with this video showing how to unprotect excel sheet without password.
======================================================================================
VBA Code to Unprotect in Method 2 (If you need to restore the password use Method 3)
Code contained in practice workbook module 1:
Code not written by myself so use at your own risk. I have simply broken out onto separate lines to allow it to be run one loop at a time with stop breaks to avoid machine lockups.
Sub sbRemoveSheetPassword()
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66
For j = 65 To 66
For k = 65 To 66
For l = 65 To 66
For m = 65 To 66
For i1 = 65 To 66
For i2 = 65 To 66
For i3 = 65 To 66
For i4 = 65 To 66
For i5 = 65 To 66
For i6 = 65 To 66
For n = 32 To 126
ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox “Complete”
Exit Sub
End If
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
End Sub
======================================================================================
#Up4Excel
#Up4ExcelAdvanced
#Up4ExcelTips
Here at Up4Excel we’re on a mission to help YOU:
» Get your Excel skills UP and your task time DOWN
» Focus on shortcuts and fast impressive results
» Improve your productivity and free up your time
Everyone will assume you work 24 hours a day to produce the kind of output you’ll be producing in no time…. with the help of Up4Excel training.
We release multiple videos each week, packed full of ways to save time and impress those around you.
💎 Don’t miss out and fall behind…..
🅾 SUBSCRIBE NOW 🅾
======================================================================================
💥 Shortcuts Cheat Sheet: »»
📘 Dynamic Chart Template: »»
✅ Download Practice Workbook: »»
🎁 Your small gift will help me make better videos for you and others.
Thank You:
======================================================================================
Nguồn: https://new-weekend.com/
Xem thêm bài viết khác: https://new-weekend.com/tong-hop/
Remove Excel sheet protection and add it back again…..all without even knowing the password. In this video I'll show you 3 ways to crack password protection on Excel sheets. make the changes you want, and then re-protect the sheet again afterwards. I go through 3 methods, getting increasingly more sophisticated and more robust.
I thought method 3 would work but there is no xl file after I zipped the file. Only [6]DataSpaces, EncryptedPackage, and EncryptionInfo
If you just want to remove the password just open the spreadsheet in Libreoffice, save it to .ODS format. I will as to enter a LibreOffice compatible password. Open the .ODS spreadsheet and save back to Excel format and password will be what you set in LibreOffice.
Great tips! Another note for others to keep in mind: these methods will not work on an xlsb file where the internal files are encoded in binary as opposed to XML. This is also a good way for others to produce a spreadsheet that is protected from these methods
I cant do anything without adding a password, cant open VBA at all and when I change it to a .zip it just says "The archive is either in unknown format or damaged"?
This is bloody brilliant!! Thank you so much!!
This is awesome !
Thanks for method 2 it works you are great!
Amazing!
This is what I looking for.
Method 3 works for me.
Thank you very much.
None of these worked for me? Especially the last one, whenever I open the .zip it only comes up with the encryption stuff?
awesome! – took barely a minute using method 2!!!
i like and subscribe because it work. Thanks
could you please explain the code which guess the password ?
Thank you SIR,
Your just amazing, I was searching to remove xls file protection from 2 days read several articles and go through vedios also but i will not succeed suddenly i found your video try first method doesn't work and used second method and its works.
Last method was soooo easy, thanks dude! Never heard of the vba thing, that's why I went for number three
how to unlock the whole workbook not only a sheet ?
Thank you so much. This is by far the clearest explanation and worked to a T and on a Mac. Really really helpful.
Method 2 is my savior. You worth a lot more subscribers!
Method 3 saved my bacon. Very cool
I WANT WORKBOOK PASSWORD REMOVE PLS HELP
THanks mate!
Hello, I canot add a sheet to insert vba code so I tried third method and removed lines as you advised but still password is not removed. As soon I click on file name in VBA editor it ask for password. Any help please?
my excel file is getting corrupted if use method 3 as soon as i unzip and zip it. method 2 freeze the excel and i cant use F11 since it protected.
Can i see the functions after we unlock the protected sheet as u said
You're awesome! Tried the steps using other videos for xlsm and yours is the only one that worked! Method 3 is nice by the way. Thank you!
genius!
Awesome. Thank´s a lot for the 3rd tip. Just a advice, some free compressing programs do not write it correctly when compacting the file again, causing the file to be "corrupt". The best way it´s to use Windows native compressing tool.
My Excel file had a password over it. I tried to try the zip method, but it is being corrupted. I used 7zip to open .zip contens, which delivered me a folder called 'Data Spaces' and two files namely 'encryption package' & 'encryption info'. have ben trying for a month. Its an important file. Please guide me further. @Up4Excel
Your video is educative and i have a password that i want to recovery i was unable to apply the methods on my excel protected sheet and would need your help
method two is magic, thank you for the help!
I used the foolproof method and crashed my file. lost my job. lost my house. dog ran away. wasn't even my dog
Thank you sir!
Superb !
well holy shit. thank you 🙂 Liked the video. Appreciate it!
Thank you sir. It worked .
nice
I tried method 3 and got stuck at opening up the xml file to notepad. For some reason the code turned into all symbols when I opened the xml in a notepad.. i'm not sure why
When I do method 3 in Excel on my mac, the file is corrupt "The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt." I don't get why it seems to work for some people and not others, since this and similar methods have never worked on my mac. I'm testing method 2, to see if it works. Right now it's running for a few minutes on my test sheet with a simple password to see if I can try it on a more complex worksheet. Thanks for the video.
No need for all these, just open the file using google sheets and all the vb code will be bi-passed then re save back to excel – done!
hi, i cannot see the contents of zip file as you shown. what i am doing wrong. please help. thx
is there a way to protect vba without getting cracked?