Unlock Excel Password Protect Sheet : If You Forget Password Use This Trick

Hello Guys, Welcome to this super blog post.

After the lock excel password sheet and if you forget the password don’t worry, Here I post how to unlock protected excel sheet password. When I face this problem and think everyone also faces this type of problem. And searching the right solution.

One day I lock the excel sheet, but after someday, I forget the password. I use this technique and unlock it my all data are safe. Not loss any data in the file.

Let’ s go for the main topic.

Here i shared to technique:

1 – Unlock using Excel VBA Script Technique

2 – Unlock Using Zip File Technique

1. Unlock Using VBA Script Technique - Excel Password Unlock Trick

This Script is for every type of guy. Don’t worry if you thought to need programming knowledge for this technique.

Step By Step:-

1. Open Locked Excel File

2. Go To Developer Menu>Visul Basic Code  (Developer Menu) / Press Shortcut Key Alt+F11

3. Copy The Script And Past It Visual Basic Page : –

Sub PasswordUnlockCrazyhacker()

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 “One usable password is ” & Chr(i) & Chr(j) & _

Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _

Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)

Exit Sub

End If

Next: Next: Next: Next: Next: Next

Next: Next: Next: Next: Next: Next

End Sub

Excel Password Unlockd

4. Click The Run Button  / Press F5 Shortcut Key

5. Finally Your Excel Sheet Unlocked

Excel Sheet Password Unlocked.

Just See it, How easy to unlock excel locked sheet without password. If this post helps you and you learn something new from this site, so share this post with your friends. Move to next Technique

2 - Unlock Using Zip File Technique

This technique is a very funny technique. Because this not a valid trick to unlock password. Let see how to work the Zip technique to unlock excel worksheet password unlock.

Step By Step:-

1. Go to the folder when your excel file saved. (  Backup a file copy for safety, In case you take the wrong step and your data lost)

2. Rename this file (Example.xlsx) to (Example.Zip) File Name

3. Open Example.Zip file And you see three .xml file (Like Sheet1.xml, Sheet2.xml, Sheet3.xml)

4. Example.Zip/xl/worksheets/ Choose your  locked sheet

5. And Open (.xml) file to notepad format

6. And Find “Password” Word ( For finding text use Ctrl+F Shortcut Key)

7. You see a script line like – “@3456345” Delete It

8. And Save this (.xml) File

9. And once rename it Example.Zip to Example.xlsx File – Your Orignal Format

10. Final Check it, your excel sheet password is unlocked

Thanks For Read Full Blog.

If your budget little bit more, so check our another handpicked most popular blog.


Leave a Reply

Your email address will not be published. Required fields are marked *