What to do if you forget your excel password

First of all, you must understand that there are two situations when you forget your password:

If you forget the password of the workbook, it is difficult to crack and you need to use special commercial software; It is the password of the worksheet that has been forgotten. There are many ways to solve it easily.

Forgetting the worksheet password means that the workbook can still be opened, but the cells in the worksheet cannot be modified.

1. VBA cracking method

Solution:

Step1: Open the workbook that needs to crack the password, press Alt F11 to bring up the VBA editing window .

Step2: Copy the following code to the VBA edit box, and then press F5 to run it.

Related recommendations: "excel tutorial"

Sub Pojie()
ActiveSheet.Protect AllowFiltering:=True: ActiveSheet.Unprotect
End Sub

##2. Conversion compressed package cracking method

This method is only applicable to Office 07 or above. In these versions, Microsoft uses xlsx, docx, and pptx formats. They are essentially a compressed package. All source code files that make up Excel are in this compressed package. , so the contents of the file can be extracted by changing its suffix to .zip or .rar.

Step1: Modify the suffix of Excel to ".zip" and click "Yes" in the pop-up menu;

Step2: Open the created Compressed package, find the corresponding encrypted worksheet (with the same name) under the xlworksheets path in the compressed package;

Step3: Use [Notepad] to find this file, [Ctrl] [F], enter "protection" Search to find the encryption code. After finding it, delete the one in together with the symbol, and then save it.

As shown in the picture, the long string of colors should be deleted.

Step4: Change the zip file suffix name to .xlsx, then open the workbook, you will find that the password has disappeared.

The above is the detailed content of What to do if you forget your excel password. For more information, please follow other related articles on the PHP Chinese website!