Skip to main content

Posts

Showing posts from March, 2018

Unlock worksheet vs unlock workbook

Unlock worksheet ( file is open but Workbook is protected)
Solution: upload to Google Docs and download as regular Excel file.

Unlock workbook (unable to get into the file because is password protected) (Source:https://community.spiceworks.com/topic/328118-need-to-unlock-a-password-protected-excel-2010-workbook?page=5)

"Press ALT   F11 or click on View Code in Developers Tabs In the visual basic Enter the below Code. 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.…