Skip to main content

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.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:"
You can also click on module one by one (Or on which workbook password is applied) on left side and then paste and press F5.

Comments

Popular posts from this blog

"Unable to open workpaper" error when the Excel is open anyway

1.serach *.xlb and delete all
2.copy epace.xla from /pfx engagment/wm/utitliy to c:/progarm files/micfosoft office/office10 (the current version)/library
3.open Excel alone, Tool>allins make sure only epace is check and browse to officexx/library and copy it
4.regedit: currnet user-software-microsoft-excel and make sure "open" key point to the correct path

Xerox WorkCenter 5655 Software Reset Procedure

Recommended by a very knowledgeable Xerox technician - perform this procedure once a month


Unplug both Ethernet and power cable for 5 full minutesHold down Print green button for 5 seconds and release, wait for 10 seconds, hold down again for another 5 secondsPlug in the power cable and power on while leaving the Ethernet cable unpluggedOnce the printer is up 100%, go to the admin console by pressing Access A buttonEnter the credential - by default it's admin and 1111 as the password.Select Tools Pathway, click on More and select Software Reset**Important** Select "Reset Both" BUT don't hit "Confirm" button yet. Plug in the Ethernet cable now, then hit "Confirm".Printer now will power cycle again.Print some test pages and the printer should respond better

Connect Plantronics Wireless Headset CS540 to Cisco IP Phone 79xx

Our receptionist needs to have the ability to answer the phone while moving around. The model of the phone is 7965. I looked around and bought the Plantronics-CS540 Convertible Wireless Headset at Amazon.com. However, it did not work. I meant I still could not answer the call or get a dial tone by pressing the button on the headset.

It turned out I also need the APC41 cable, PLUS a configuration change on Cisco Call Manager or Cisco IP phone if you have permission to do so. The change is to ENABLE "Wireless Headset Hookswitch Control".

The APC41 should support 7942G, 7945G, 7962G, 7965G and 7975G.