You can use the code to unprotect the sheet now.Įxcel worksheet protection is an amazing feature giving you the flexibility to lock or unlock certain cells using a password. A dialog box containing a usable code will pop up. Step 5: After running the code, you'll be redirected to the worksheet. Do this by hitting F5 on your keyboard or by clicking " run" from the menu atop the VBA code editor. If ActiveSheet.ProtectContents = False Then Paste the following code.ĭim i As Integer, j As Integer, k As Integerĭim l As Integer, m As Integer, n As Integerĭim i1 As Integer, i2 As Integer, i3 As Integerĭim i4 As Integer, i5 As Integer, i6 As Integerįor i = 65 To 66: For j = 65 To 66: For k = 65 To 66įor l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66įor i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66įor i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126ĪctiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _Ĭhr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _ Step 3: Select Insert > Module from the menu. Open the program and select the option of " Remove Restrictions". You can remove restrictions from Excel workbook/worksheet by following these steps. We offer 30-day money back guarantee if users have any tech issues with our software.įree Download for Win 11/10/8.1/8/7/XP Free Download for macOS 10.9-13 It is totally secure to use Passper as it is the sub-brand of the highly recognized authorized iMyFone.
Super useful to unprotect your Excel sheet and cells. Following are some of the features of Passper for Excel software: It has amazing features and capabilities to recover the lost or forgotten password. Passper for Excel is one of the most popular and powerful tools to recover the opening password and remove restrictions for MS Excel as it guarantees its users that no data will be deleted from the sheets or the workbooks. Unlock Cells in Excel Even if You’ve Forgotten the Password 2.1 Using Excel Password Recovery Software (Easy Way) Now, the certain cells that you chose before is unlocked while other cells is locked. Step 4: Confirm the password you entered. You can type in a password to enhance the protection. Step 3: Right click on the sheet name and choose " Protect Sheet".
0 kommentar(er)
