{"id":208,"date":"2015-07-09T12:11:19","date_gmt":"2015-07-09T16:11:19","guid":{"rendered":"https:\/\/www.ccrossan.com\/?p=208"},"modified":"2016-07-07T08:03:17","modified_gmt":"2016-07-07T12:03:17","slug":"unprotect-an-excel-worksheet","status":"publish","type":"post","link":"https:\/\/crossan007.dev\/blog\/tools\/unprotect-an-excel-worksheet\/","title":{"rendered":"Unprotect an Excel Worksheet"},"content":{"rendered":"\n
Tweet<\/a><\/div>\n

C\/O: https:\/\/uknowit.uwgb.edu\/page.php?id=28850<\/a><\/p>\n

    \n
  1. Press ALT+F11<\/li>\n
  2. Double Click the worksheet in question<\/li>\n
  3. Paste the Following Code:\n
    \r\n\r\nSub PasswordBreaker()\r\n\r\n'Breaks worksheet password protection.\r\nDim i As Integer, j As Integer, k As Integer\r\nDim l As Integer, m As Integer, n As Integer\r\nDim i1 As Integer, i2 As Integer, i3 As Integer\r\nDim i4 As Integer, i5 As Integer, i6 As Integer\r\nOn Error Resume Next\r\nFor i = 65 To 66: For j = 65 To 66: For k = 65 To 66\r\nFor l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66\r\nFor i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66\r\nFor i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126\r\nActiveSheet.Unprotect Chr(i) &#038; Chr(j) &#038; Chr(k) &#038; _\r\nChr(l) &#038; Chr(m) &#038; Chr(i1) &#038; Chr(i2) &#038; Chr(i3) &#038; _\r\nChr(i4) &#038; Chr(i5) &#038; Chr(i6) &#038; Chr(n)\r\nIf ActiveSheet.ProtectContents = False Then\r\nMsgBox "One usable password is " &#038; Chr(i) &#038; Chr(j) &#038; _\r\nChr(k) &#038; Chr(l) &#038; Chr(m) &#038; Chr(i1) &#038; Chr(i2) &#038; _\r\nChr(i3) &#038; Chr(i4) &#038; Chr(i5) &#038; Chr(i6) &#038; Chr(n)\r\nExit Sub\r\nEnd If\r\nNext: Next: Next: Next: Next: Next\r\nNext: Next: Next: Next: Next: Next\r\nEnd Sub\r\n<\/pre>\n<\/li>\n
  4. Press the Run button<\/li>\n
  5. The password to unlock the form is displayed, and the sheet is no longer password protected<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
    C\/O: https:\/\/uknowit.uwgb.edu\/page.php?id=28850 Press ALT+F11 Double Click the worksheet in question Paste the Following Code: Press the Run button The password to unlock the form is displayed, and the sheet is no longer password protected<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[53],"tags":[89,175,47,90,173,174],"yoast_head":"\n\n\n\n\n\n\n\n\n\n\n\n\t\n\t\n\t\n