Our company uses a face time machine, and then the downloaded report needs to cancel the protected worksheet, and after finding the unlocked password, you can download the report next time directly by entering the password, or directly unlock all the reports without entering the password for each one. Maybe sometimes the password will be set to protect the worksheet from being lost. It doesn't matter if the password is forgotten. Let me show you how to do it.
Operation method
First, open the Excel software, and click Review on the page to revoke the worksheet protection. This means that the Excel form has been locked with a password, and you must enter the password if you want to modify it. However, there is a way to break the password.
At first, click View - Macro - View Macro, and then a small box will appear. Enter hh (any letter is OK) in the top "Macro Name", and then click Create to appear in step 3.
Delete Sub (hh) - sub (end), and a series of codes will appear when you search for the code to undo the worksheet macro on the Internet. Copy and paste it on this blank page.
The following picture is the one that has been pasted. Please note that you can not paste a word less, or you will not be able to unlock the password.
Then click the tool macro, and the word Allinternal Passwords will appear. Click Run.
After running successfully, it will return to the original page and display these English words, but just press the Enter key. This completes the unlocking.
Now you can click Review Query to check whether the protected worksheet is displayed. If it is, the unlocking is successful.
hot tip
It's very simple. I will