-->

How to Unprotect Excel Worksheet without Password

How to Unprotect Excel Worksheet without Password? Why do we need it? This is because I forgot the password on the excel worksheet, so I can't edit the excel document that I have created. Or find excel document that is password protected.
 
Well, my friends, don't worry and panic when you forget your Excel password, or you want to open a protected Excel document. Below we will share a tutorial on how to complete How to Unprotect Excel Worksheet without Password. see the details below.
 

How to Unprotect Excel Worksheet without Password

 
We need to say first, that in this tutorial on unprotect Excel document tricks using Microsoft Office 2019. However, this trick is general and you can use it in other versions of Microsoft Office Excel.
 
The following tricks are very easy, good for beginners. For step by step, how to unprotect Excel without using a password is as follows:
 
The first stage
  • Open the excel file that you want to unprotect the sheet or worksheet for
  • Open a specific sheet by clicking on the sheet (for example sheet1, sheet2, or another sheet) right-click the sheet, then select “VIEW CODE” or in other ways press "Alt + F11" keys on the keyboard simultaneously.
  • Immediately a Microsoft Visual Basic window will appear, then select insert MODULE. For more details, see the image below.
view code microsoft visual basic

microsoft visual basic excel
 
The second stage of How to Unprotect Excel Worksheet without Password, is to enter the code below into the Insert MODULE window. The code is as follows: 
 
Sub InternalPasswords()
 
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
 
ActiveWorkbook.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)
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 ActiveWorkbook.ProtectStructure = False Then
 
If ActiveWorkbook.ProtectWindows = False Then
 
If ActiveSheet.ProtectContents = False Then
 
Exit Sub
 
End If
 
End If
 
End If
 
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
 
End Sub
 
The display in the second step should be as shown below.
 
Unprotect Excel Worksheet

 
Third step
 
The next step in How to Unprotect Excel Worksheet without Password is to run the command code in the Insert MODULE window above. The method is as follows:
  • Through the menu bar, click TOOLS, then select MACROS, then click RUN and wait a few moments until the process of executing the command is complete.
 
run command visual basic excel
  • Another way To run the Run command, you can also access it on the toolbar by clicking the Run button
  • After the command is complete, then exit the Microsoft Visual Basic window by clicking the close (x) in the upper right corner or by clicking FILE (left corner) then selecting COLE AND RETURN TO MICROSOFT EXCEL
 
Done, after you have done all the steps above correctly, the protect sheet should be gone. For unprotect sheet on other sheets, you can do with the steps as above.
 
Note:
  • To be more secure and do not change the original file, it would be better if you save an unprotected sheet or worksheet file with a different name. (Save as)
  • If the EXCEL file is in the form of MACRO ENABLE WORKBOOK, then save as first the file to the type or type EXCEL WORKBOOK file.
 
Easy is not friends How to Unprotect Excel Worksheet without Password. Hope this is useful.
SeeTutupComments