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;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!