For some of our more important forms, such as bookkeeping forms used to record household expenses and password forms for logging in to various websites, we usually protect them with our own private passwords, but what if one day, by coincidence, we even forget these passwords?
Prompt the password screen, if you do not enter the correct password, this Excel sheet is not editable. Is it necessary to violently decrypt? In fact, it does not even need to be so troublesome, we can use a workaround to clear this Excel worksheet to protect the password.
As shown in the figure, this Excel file is no suffix, we need to modify its suffix first, and then to achieve the purpose of clearing the password. Method is, click the tab to switch the folder to “View” item, and then check the “file extension”, so that Excel tables show the suffix name.
Next, we right-click the Excel file and select “Rename” to modify the form suffix name.
Circle the suffix “xlsx” and change it to a zip file suffix such as “zip” or “rar”, then it will prompt “If you change the file extension, it may cause the file is not available”, ignore it, click “Yes” to determine.
Double-click the file which is modified into a zip file, open it and go to “worksheets” under the “XL” directory, find sheet1.xml and double-click it, then it will prompt how to open the file, we choose other options in “Notepad”.
In Notepad, press the shortcut Ctrl+F, search for the keyword “protect”, locate the content similar to the following, drag the left mouse button, select <sheetProtection> including the brackets and all the content in the brackets, delete it, and then save to exit.
After completion, we just need to go back to the folder just now, the file with the .zip extension back to the Excel file extension .xlsx (or .xls). So far, double-click the file you will find that the protection password is gone, is not very simple?
If this method does not work, for example, the latest version of Office Excel does not support, then we have another way to crack – through the macro function can also achieve the same purpose. To use this method, or open the Excel file with the worksheet password protection, and then click on the “File” option.
In Excel Options, switch to “Customize Ribbon”, find “Development Tools” on the right to check it, and then click OK.
Go back to the Excel spreadsheet, click on “Development Tools” above and select “Record Macro”.
Click OK in the pop-up window to start recording the macro, and then click “Stop Recording” in the development tool.
At this point, we have a “blank macro”, click “Macro” in the development tools, a pop-up window click “Edit”.
In the macro editor that pops up, we delete all the content (actually no content), then download the macro code (download address: https://pan.baidu.com/s/1BdMhmKKXfOIUXAOJVGZ30A, extraction code: tcp0), copy all the macro commands to the current macro editor window, and click Close.
Click again to develop tools in the “macro” can see a new macro “Password_cracking”, select the macro click on the implementation, Excel worksheet to protect the password is cleared.