![]() If you feel above way is a little difficult, or it is not so safe enough for your excel file, this way will suggest you another more effective and safe software. Way 2: Unprotect Excel Sheet/Workbook safely with iSunshare software Tips: You can use this power way only to unprotect or unlock your own worksheets. It means it is the usable code that has helped to unprotect your worksheet. Just click OK in the box and you can see your worksheet become unprotected. Then the Macro will return you to the worksheet you want to unprotect. Step 4: Unprotect worksheet with generated code. Once the code is added correctly, run the Macro by pressing F5 or selecting Run Run Macro in the menu of VBA editor. ![]() If ActiveSheet.ProtectContents = False Then Step 2: Copy and paste following VBA code in general declarations page.ĭ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) & _ This will open the general declarations page for the sheet. ![]() ![]() In VBA project, double click the sheet you need to unprotect from the menu listing in the left or on the top. Open the worksheet you forgot password to unprotect. If you just want to unprotect excel worksheet after forgot sheet password, this freeway is worth trying.ġ. Way 1: Unprotect Excel Sheet free with VBA code Way 3: Unprotect Excel sheet/workbook safely without password - Remove protection tag.Way 2: Unprotect Excel sheet/workbook/spreadsheet/worksheet safely with iSunshare software.Way 1: Unprotect Excel sheet/spreadsheet/worksheet free with VBA code.Tips: If you forgot the open password to Excel file, please see how to open password protected Excel file without password. Note: You can also use VBA code to protect a sheet.How to Unprotect Excel Sheet/Worksheet/Workbook without Passwordįorgot password to unprotect excel file or sheet? Now this article would introduce three effective methods to unprotect Excel (xls/xlsx) sheet/workbook/spreadsheet/worksheet without password while excel file is protected by open password or modify password. This means you have completely protected your worksheet from viewing. Now, if you try to unhide the sheet, you’ll see that the unhide option is disabled. Reenter the password to confirm and click OK.In the Ribbon, go to Review > Protect Workbook. Right-click the sheet you want to protect (here, Sheet1), and click Hide.To completely lock a sheet for viewing, follow these steps: You can hide Sheet1 by right-clicking it and selecting Hide.Īs a result, this sheet is hidden, but if you right-click on any of the other sheets’ tabs, you can unhide it by clicking Unhide. Say you have an Excel file with three sheets (Sheet1, Sheet2, and Sheet3). If you only hide the sheet without protecting it, users can still unhide the sheet and view it. In Excel, you can completely hide and protect a worksheet from being viewed by hiding and then protecting the worksheet. This tutorial will demonstrate how to password protect an Excel sheet from being viewed.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |