If ActiveSheet.ProtectContents = False Then Sub Unprotect_Sheet_If_Password_Forgotten()ĭim a As Integer, b As Integer, c As Integerĭim x As Integer, y As Integer, z As Integerĭim z1 As Integer, z2 As Integer, z3 As Integerĭim z4 As Integer, z5 As Integer, z6 As Integerįor a = 65 To 66: For b = 65 To 66: For c = 65 To 66įor x = 65 To 66: For y = 65 To 66: For z1 = 65 To 66įor z2 = 65 To 66: For z3 = 65 To 66: For z4 = 65 To 66įor z5 = 65 To 66: For z6 = 65 To 66: For z = 32 To 126ĪctiveSheet.Unprotect Chr(a) & Chr(b) & Chr(c) & _Ĭhr(x) & Chr(y) & Chr(z1) & Chr(z2) & Chr(z3) & _

Next, type the following VBA code in that blank code window:.

Afterward, a blank VBA code window will appear.

Furthermore, right-click on the sheet name.

The above command will open the Visual Basic window.

To begin with, go to the Developer tab.

Let’s see the steps to perform this method. Then we will apply the VBA code in the new format. But, if we are using the later versions of Microsoft Excel 2010, we have to convert the file in Excel 97-2003 workbook (*.xls) format first. We can use the code of this method directly in Microsoft Excel 2010 or earlier versions. Unprotect Excel Sheet with VBA If Forgot Passwordįirst and foremost, we will use a VBAcode to unprotect an Excel sheet if we forget the password. It gives us the warning that the worksheet is protected.ġ. More specifically, if we try to make any changes to the worksheet, a message box like the following image will appear. We can see that many commands under the Home tab are not available as the worksheet is password protected.

Now notice the ribbon under the Home tab. To illustrate the methods we will use the following dataset that contains several different food types and their average price. Throughout this article, we will show 4 effective methods to unprotect an Excel sheet if we forgot the password. 4 Effective Methods to Unprotect Excel Sheet If Forgot Password

How to make excel sheet unprotected