3 Ways To Unprotect Excel Sheets: Crack AND Restore Unknown Passwords

🎯 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.

======================================================================================
🕑 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 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:
» 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.

💎 Don't miss out and fall behind.....
🅾 SUBSCRIBE NOW 🅾

======================================================================================
🎁 Your small gift will help me make better videos for you and others.

[srikantagrawal]

I wanted to disburse salary in bulk to our company employees. But my bank provided a protected sheet to upload the details, which was very very difficult to operate. Few cells were locked unnecessarily. Could not move or make any changes to a particular row. I already complained to the bank. But nothing happened. Your method 3 solution worked like a charm and saved me from repeat frustration I was going through for past couple of years. Now I am super excited. Why did I not look up your video earlier!!
Thank you so much.

[zmilan]

I know this is a small reward for your work and effort in putting these videos together. I wanted to thank you and at least buy you a coffee.
Best!

[carolgarrison]

Tried hacking the code multiple times without success, so just finding the "password" in the code so much easier! Thanks!

[ShirtlessRabbit]

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

[manishsane]

Method 2 I tried for whole of night but didn't complete- so chose 3rd solution and wola great! Had 5 sheets with protection. So dis this 5 times and then merged those individual sheets back into a new file. Thanks a ton

[jaqueline]

I tried different modes, but only this worked.
Excellent!!!

[akshaygmukhekar]

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.

[LlamaOates]

Method 2 worked for me in less than a minute. Stupid financial course i am doing protected the the sheet to hide their formala's, but annoyingly I wanted to build on it and make some edits of my own. Good video, nice and clear and easy to understand.

[lyamhtv]

Got it! Method 3 is very much effective sir, thank you thank you so much...🙏🙏🙏 God bless you always...

[aditya.latchireddi]

Method - 3 highly recommended... Thanks a lot sir... 👍👏✌️🤗

[TheSprCch]

Thank you! Method 2 was exactly what I needed! :)

[tafadzwatinoona]

Wow, method 3 worked for me and saved me tones of work.

[terrastructeng]

I had a couple very useful files that I wrote back in 2013 and could not remember some parameters. You saved me like a day of work. Thanks!

[ajmarch]

Number 3 was the rescue for me. I was testing out the security of workbook by trying random words, lo and behold i accidentally changed it to a random bunch of letters with no rhyme or reason lol. I tested it on one sheet and it worked. Just another 157 sheets to go!!! Thanks for the help dude.

[husseinahmad]

I did the first method and it was done successfully... Thank you so much for sharing ❤️

[direguineapig]

Method 2 worked! Though I'm now running into the issue where coworkers think I'm good at excel

[jorgegranados]

Option 3 works great for us. You save our lives. Thanks

[forzanibusinesssolutions-tv]

What software are you shooting this video with?

[rawconcept]

Wow!!! Thanks boss, method 2 worked for me like magic....

[rivelnzeukou]

Your assistance is much appreciated! Method 3 worked for me.