We many times receives excel files from various sources. Sheets of  which are password protected by the author of the file. Sometimes we need to change the content of the file to suit our requirements but we will not be able to  make the changes if the excel sheet is password protected. This document will tel you how to unprotect an excel spread sheet without having the password.

In case of a password protect worksheet you are unable to Edit the data on the Excel Sheet. If you do not Remember the Password or do not know the password to unprotect the sheet just follow the below simple steps.

Press ALT +  F11 or click on View Code in Developers Tabs  Excel2

Choose the Sheet No. or Sheet Name which you want to un-protect and then In the Above White Space Enter the below Code (In Italics).  Do not change the code just copy paste:

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 Click on the Run Button or press F5: Excel3

And there you go the sheet is unprotected for you now. Also you would be getting a message in the pop up window.

This Message is contains the password which can be used to unprotect the other sheets in the same workbook.

 Excel4

Source – University of Wisconsin- Green Bay- USA

More Under Finance

Posted Under

Category : Finance (3748)
Type : Articles (18224)
Tags : Excel Tips (36)

42 responses to “How to Unprotect an excel sheet without password (Updated)”

  1. Chinmoy Mitra says:

    Sorry, this does not work. When I try to select a worksheet in visual basic editor, I am again asked for the password, so it simply defeats the purpose of this tutorial. Please try it yourself before posting such ideas. Thanks

  2. Mahesh says:

    Thanks but this is for a single spreadsheet password breaker

    But we are looking for entire worksheet password breaker

    pl share if any utility

Leave a Reply

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

Featured Posts