How to unprotect an excel sheet without any software - Software Applications - MS Excel - TIK Share

How to unprotect an excel sheet without any software


Vedanta Deshika

2013-12-27

Hi guys,

 

Just press ALT +  F11. It will take you to Visual basic screen. Now on the left hand corner, you can see VBA Project ( File Name). Under that, you will find Excell sheets as Objects.

Just double click one object.

A White sheet will open

Now. Copy paste the following code.

Sub PasswordBreaker()
    'Breaks worksheet password protection.
    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

now press F5 button.

Thats it . You are done.  The program automatically produces a password and pops up . just copy that password.

Now u can unlock the excel workbook with this password

Enjoy

CA Pulkit Sharma

2013-12-28

Hi its not working. Can you upload a file with this code to test.

I tried to protect a sheet and than use this code but did not work properly.

Reply

Vedanta Deshika

2013-12-28

Pulkit , u just send me that protected excel sheet. i will send u back after unlocking it with this code only

Reply

saya mason

2014-03-12

Without any excellent software it is impossible to unprotect a password protected Excel sheet. When I am come across from the same situation then I use Excel Password Recovery Software. This software gives best solution by unlock MS Excel files within few minutes.
Visit here:-
http://www.excelpasswordrecoverysoftware.org/
http://www.excelpasswordunlocker.org/

Reply

CA Pulkit Sharma

2014-03-12

Can you make a dummy excel file and put the code than upload? I will look at the file with codes.

Reply

Vedanta Deshika

2014-06-26

Pulkit stop complaining everytime, it really works and have tried for myself for many excel files

Reply

CA Pulkit Sharma

2014-06-27

I could not do it yet. Why dont you do it in a excile file and upload here. well the forum is to discuss and ask doubts. So i ask doubts.

Reply

Vedanta Deshika

2014-06-27

Pulkit

 

U just upload a password protected excel sheet and i will unprotect using this code and upload it back.. May be u are having some issues in your ms office or your lappy itself

Reply

Kaye R. Jenkins

2016-11-22

http://unlockexcelpasswordrecovery.blogspot.in/2016/08/unlock-excel-password-recovery.html program you can break protection password Excel sheet and quickly re-open locked MS Excel file with no trouble.

Reply