![]() ![]() If we now password but the tab "Unprotect sheet" inactive, you should choose "Editing", button "Access to workbook", then remove tick "Allow multiple users to edit file ". ![]() Open file by double-clicking and voila!!! Everything works!!! The Protecting cells function in a sheet is used where you do not want to view or delete the formulas. ![]() Delete all container " sheetProtection" from "".Ĩ. In this article, we will learn protecting cells that contain formulas in a protected sheet in Microsoft Excel 2010. Extract file " sheet1.xml" from container XLSX and open by text editor. So in path "File.xlsx/xl/worksheets/sheet1.xml" or " sheet2" or something else is that one password-protected sheet. You can open its by TotalCommander - put it on cursor and press Ctrl + PageDown If ActiveSheet.ProtectContents = False Then Open menu Service - Macros - Visual Basic Editor (or press Alt+F11), insert new module (menu Insert - Module) and copy there this code: Sub Password_Cracker()ĭ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 In attached file is program which shows passwords for all worksheets of the workbook in Microsoft Excel. ![]()
0 Comments
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |