How to Remove, Crack, or Break a Forgotten Excel - Knowledge World

I as of late had the condition where a customer sent me a duplicate of a bookkeeping page that was secret word ensured, anyway the customer not, at this point had the secret phrase to open the substance. They were contemplating whether there was anything we could do… 

So how would you unprotect an Excel bookkeeping page when you don't have the secret phrase? Tragically, there is no fast and basic path for you to see or recuperate a lost secret key. 

Read More: How to Make a Log Book in Excel - Knowledge World

So what do you do in the event that you have lost the secret key to unprotect a dominant exercise manual or worksheet? 

The accompanying technique MAY, we re-emphasize MAY, work for you, yet on the other hand it may not also. We have had a decent measure of achievement utilizing this strategy yet it has not worked 100% of the time. Having said that, the technique doesn't hurt your bookkeeping page nor information, so you don't have anything to lose from attempting it. 

The most effective method to unprotect a secret key secured worksheet. 

So what do you do… 

On account of a secret phrase secured worksheet where you can't edit the information, you can attempt the accompanying strides to unprotect your worksheet.  manual or worksheet? 

Stage 1: Press ALT +  F11 or click View Code on the Developers Tab

Stage 2: Double snap on the worksheet that is secret phrase ensured. 

Stage 3: Copy and Paste the code underneath into the (Code) window. Try not to change any of the code, simply reorder it. 

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

Stage 4: Click on the Run Button or press F5. 

Also, the writing is on the wall. 

In the event that this technique worked and had the option to unprotect your worksheet, you'll a little spring up window saying "One usable secret key is XXXYYYZZZXXXY".

-- Thank You