Way to Unprotect a Microsoft Excel Sheet: Tutorial
Do you also want to unprotect a Microsoft Excel Sheet? If your answer is yes so then you must have to follow the following guide. Because here we are going to solve this question. Well, when someone makes an Excel spreadsheet so they don’t like others to turn, they will often protect individual sheets. However, guarding an Excel worksheet call for making a password. Similarly, you have to enter whether you like to create conversions to the sheet.
A number of methods are also there for unprotecting an Excel sheet like this. The first is clearly typing the password and also unprotecting the sheet. But whether you have forgotten or unremembered the password or the person who locked it did not provide the password to you, so now you are not out of luck. Two other methods are also there to unprotect that sheet.
Way to Unprotect an Excel Sheet with the Password
However, the simplest method to unprotect an Excel sheet is whether you know the password.
- Tap on the Review tab.
- Secondly chooses the “Unprotect Sheet” in the Protect part of the menu.
- Then you have to type the password in the Unprotect Sheet dialogue window.
Way to Unprotect an Excel Sheet with Google Sheets
However, losing or unremembering the password on a protected Excel worksheet can be scary. Your first thought probably be is just that you have fully lost all the data in the sheet.
Fortunately, the good news is for you that there’s a creative workaround that permits you to unprotect an Excel sheet. Now you will need a Google Drive account, however, for doing this.
- First of all, you have to head to your Google Drive account. Choose the New and also select Google Sheet to head to a new sheet.
- Now in the sheet, you must have to choose the File and select Import.
- Simply now in the Import file dialogue box, you should choose the Upload from the menu.
- At this point, you have to select a file from your device.
- Browse the Excel spreadsheet on your PC. However, choose it, and then you must tap the Open.
- Now finally in the Import file window, you should choose the Replace spreadsheet and select Import Data.
Although this is able to import the protected Excel worksheet into your Google Sheets worksheet. Here you will notice that the sheet is no longer protected. Thus now you are also able to edit it all you like.
Now that it’s unprotected, you are also able to export the sheet back to Excel format again.
- For doing this you have to first of all, in the now unprotected Google Sheet, choose the File and Download as
- Now choose the Microsoft Excel (.xlsx)
- Select Save As.
- Here you have to give the file a name and select Save.
Furthermore, now you have the same exact Excel sheet, but the protection is cleared now.
How to Unprotect an Excel Sheet with VBA
Whether you do not have a Google Drive account, or you are viewing for another offer in order to unprotect an Excel sheet from inside Excel, VBA is the best method to perform it.
The idea is to just survey a VBA module however, that will attempt to crack the password one character at once. Depending on how difficult the password is, and the script is also able to take from 10 minutes up to hours to run.
Save as Older Excel File
The restriction on this procedure is that it just works on Excel worksheets in Excel 2010 or older. This is not a big issue, so long as you save the protected worksheet to an older version.
- For this, you have to tap the File and Save As. Simply for the format scrolldown, choose Excel 97-2003 (*.xls)
- However, it is an agony to have to save to a previous format. Although but the benefit is that at times the VBA script is completed, so then the password is cracked and you have access to the unlocked sheet.
Establish & Run VBA Code
Guys, now you will learn the way to organize and also run that VBA code.
- For doing this you just have to choose the Developer menu item in your ribbon. Whether it is not there, tap File > Options > Customize Ribbon, switch Choose commands from to All Commands, and move Developer from the left menu to the right one. Here tap OK when you are complete.
- Now in the Developer menu, choose the View Code from the Controls section of the ribbon.
- Finally, at this point, you must have to Rick-click on Microsoft Excel Objects, choose Insert, and select Module.
Similarly, there is a familiar VBA script that’s been around for years. Similarly, that will break the password and also unprotect any worksheet.
Copy the code below and paste it into the module:
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 "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
Thus then you must press the Run button in order to the script.
Therefore this will also manage the current module that you have made. It will attempt to crack the sheet protect password one character at once. Similarly, during a test with just three simple characters (“abc”), the script took seconds to crack the password.
Hence the password that is shown will be arbitrary. now you have to just press OK and your Excel spreadsheet is now unprotected again. Test typing into a cell to make sure.
After all, an easy password only takes a few seconds, however, a password that is longer and more complicated probably takes up to a minute or two. So you have to just ignore it running in the background till the message box comes up.
Simply at a time, your worksheet is unprotected, now you are also able to resave it to the older format you were using before you saved it.
Selecting Your Unprotect Method
Remember that all three of these methods will work best. But it is better, to begin with, the easiest and work your way down the list. Preferably, now you will know the password and you are also able to unprotect the sheet simply by typing it in.
But losing a protection password is very simple, so hopefully, the last two procedures listed above will support you to obtain you out of a jam and also allow you to edit your worksheet again.
Must read this article: Tips To Draw In Microsoft Word _Tutorial
Furthermore, this tutorial displays how to protect Excel sheets with or without passwords. However, it is also able to describe how to unlock an Excel spreadsheet without a password whether you forgot or misplaced it.
Similarly, when sharing your worksheets with other people or sending your Excel files outside of your organization. So then you probably like to stop other users from changing cells that shouldn’t be changed, and also from moving or removing the essential data in your worksheet or workbook. Alright! I hope that you will like this guide. If you have any questions so then you can ask us in the comments below.