14 December 2014

How to Unlock Cell Excel Password Protectable Without Software

For the safety of the data that have been made, usually performed by the user is to provide a password in the file that it creates. Thus, not everyone can open the file and used as good as his own. The data is usually in the form of protectable important data that should not be changed by people who are not interested in it. In the data created in MS Excel can also be protectable or secured with a password or a password to be able to edit or change it. Usually that is often given passwords are cells that are specific formula that should not be changed arbitrarily. When you change the data in the cell that protectable, will appear in order to enter the password window

The password when freshly made, will be safe alias will still remembered in the head. However, if the file has not opened because there are new files, then it could be a password or a password that first made into oblivion. Consequently you yourself can not edit the file that you created yourself. To overcome this problem, you can use the following ways.

How to Unlock Cell Excel Password Potectable Without Software

  1. Open the excel file that cell given protected.
  2. Press Alt + F11, it will display a window in Microsoft Visual Basic For Application.
  3. Click Insert and then select Modules
  4. How to Unlock Cell Excel Password Protectable Without Software
  5. Copy the code below and paste it in the window that appears module.
  6. Sub PasswordBreaker() 'Author unknown but submitted by brettdj of www.experts-exchange.com 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) ActiveWorkbook.Sheets(1).Select Range("a1").FormulaR1C1 = 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
  7. Then click save
  8. How to Unlock Cell Excel Password Protectable Without Software 2
  9. Still in the Microsoft Visual Basic window, click the Tools menu, then select Macros
  10. How to Unlock Cell Excel Password Protectable Without Software 3
  11. After that comes the macros window and click Run
  12. How to Unlock Cell Excel Password Protectable Without Software 4
  13. Appears popup and click OK
  14. Congratulations ... .. A locked cell can already be reopened

0 Komentar untuk "How to Unlock Cell Excel Password Protectable Without Software"