Password protected MS Excel worksheet

1740 pts.
Tags:
Microsoft Office
Does anyone know if there is a work around to removing password protection on an MS Excel worksheet when the original password is unknown?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Cglancy
    If you can open and view the protected workbook a simple work-around is to copy and paste the data into a NEW workbook. The protection rights are NOT carried with the data. So for each worksheet in the protected workbook; 1) Select all data on the worksheet (mouse click on the top left cell above the row number indicators) 2) Edit "copy" 3) Open a NEW workbook 4) Edit "paste" the copied data into the new workbook 5) Save the new workbook If the protected workbook has mutliple sheets just copy/paste each into the new workbook. You do not have to create a new workbook for each worksheet (unless you want to). If a worksheet is too large to copy all at once then you'll have to manually select rows and copy/paste them into the new workbook until all of the data has been copied. Hope this helps. Constance
    0 pointsBadges:
    report
  • Aabyag
    a pass word protected excel sheet is able to be cut / copied to a new work sheet by a third person and doing so the protection is lost. to prevent this the ptotected excel sheet should not be able to be cut / copy any person who do not know the pass word.
    10 pointsBadges:
    report
  • AndreaF
    Seems to me that a person shouldn't be able to get access where they can copy & paste the workbook, if they don't already have the password to open the workbook?
    8,140 pointsBadges:
    report
  • Moto
    we came across this issue when someone left our company. we could not open the file since it prompted for a password to open the file. we ended up purchasing a program called Excel Recovery Pro. Works great, of course it'll cost you.
    460 pointsBadges:
    report
  • EricSP2012
    Use this macro

    Sub PasswordBreaker()

    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

    10 pointsBadges:
    report
  • insvpsl
    Use the below code for removing excel password

    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
    10 pointsBadges:
    report
  • TomLiotta
    If code exists that can easily bypass password protection for any business object, it shouldn't be published here. -- Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following