After that, press the Ctrl + S key to save the code and then, close the Visual Basic window.

If ActiveSheet.ProtectContents = False Then

In the third step, type the code in the Module window:ĭim x As Integer, y As Integer, z As Integerĭim a As Integer, b As Integer, c As Integerĭim x1 As Integer, x2 As Integer, x3 As Integerĭim x4 As Integer, x5 As Integer, 圆 As Integerįor x = 65 To 66: For y = 65 To 66: For z = 65 To 66įor a = 65 To 66: For b = 65 To 66: For x1 = 65 To 66įor x2 = 65 To 66: For x3 = 65 To 66: For x4 = 65 To 66įor x5 = 65 To 66: For 圆 = 65 To 66: For c = 32 To 126ĪctiveSheet.Unprotect Chr(x) & Chr(y) & Chr(z) & _Ĭhr(a) & Chr(b) & Chr(x1) & Chr(x2) & Chr(x3) & _.Secondly, select Insert and then, select Module to open the Module window.First of all, go to the Developer tab and select Visual Basic.Let’s follow the steps below to learn the method. Moreover, we can use this method in all versions of Microsoft Excel. Applying VBA is easy and most of the time it works smoothly. In the first method, we will learn to unprotect an excel sheet without a password with VBA. Apply VBA to Unprotect Excel Sheet without Password

If we try to make any change in the sheet, a message box appears.

To explain the methods, we will use a dataset that contains a weighted scoring model in a protected sheet. 4 Ways to Unprotect Excel Sheet without Password

Remove protected view excel