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.
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 IntegerDim l As Integer, m As Integer, n As IntegerDim i1 As Integer, i2 As Integer, i3 As IntegerDim i4 As Integer, i5 As Integer, i6 As IntegerOn Error Resume NextFor i = 65 To 66: For j = 65 To 66: For k = 65 To 66For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126ActiveWorkbook.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 ThenIf ActiveWorkbook.ProtectWindows = False ThenIf ActiveSheet.ProtectContents = False ThenExit SubEnd IfEnd IfEnd IfNext: Next: Next: Next: Next: NextNext: Next: Next: Next: Next: NextEnd Sub
The display in the second step should be as shown below.
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.
- 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.
- 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.