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.


6 thoughts on “How to Unlock An Excel Spreadsheet – CrazyHacker

  1. Good way of telling, and pleasant post to take data on the topic of my presentation focus, which i am going to convey in university.|

  2. Hi, I think your site might be having browser compatibility issues. When I look at your blog in Opera, it looks fine but when opening in Internet Explorer, it has some overlapping. I just wanted to give you a quick heads up! Other then that, excellent blog!|

  3. I don’t know whether it’s just me or if everybody else encountering issues with your site.
    It looks like some of the text on your posts are running off the screen. Can somebody
    else please comment and let me know if this is happening to them as well?
    This could be a problem with my browser because I’ve had this happen before.
    Many thanks

  4. It is in reality a nice and helpful piece of info. I’m glad that you simply shared
    this useful info with us. Please keep us informed like this.
    Thank you for sharing.

Leave a Reply

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