Excel worksheets exported by fingerprint attendance machine are protected and have no password. How to crack it? Ask for advice on how to crack it, please help.

In our daily work, we don't want our colleagues to change the contents of the worksheet. We usually set passwords in approved and protected worksheets.

In this way, when colleagues open your worksheet, they can only view the data, but can't edit or modify it, and the editor will pop up a warning prompt.

Sometimes, you set a password-protected worksheet, and when you want to edit it yourself, you forget the password to unprotect the worksheet, so you can't edit it. This is awkward at this time.

Today, I teach universities two ways to break the protection of worksheets.

The first method is to compress the package.

Rename the file and change the suffix to. Rar format.

Double-click directly to open the compressed package, find which worksheet is protected under xl/worksheets, select which worksheet, and open it with the internal viewer.

Press CTRL+F to find the location of content protection, and then select.

When closing, select the updated contents in the compressed package, and then change. Files in rar format. Xlsx format.

Double-click to open the form file, the protection password of the worksheet will be deleted, and the contents inside can be edited freely.

Method 2: Use VBA code method.

In the above method, if multiple worksheets have protection passwords, it is still troublesome to search for protect in multiple tables. I suggest you use the following VBA code method, just copy and paste, and delete multiple worksheets at the same time.

In the development tool, click VBA, then right-click and insert a module.

Enter the code in the module, run it directly and crack it directly.

The code is as follows:

Sub to crack the worksheet password ()

Dim a into a worksheet

For each a in the worksheet

A. protect AllowFiltering:=True

A. Withdrawing protection

then

End joint

Have you learned? Try it ~

I forgot my password. What should I do?

There are too many passwords now. You may forget them one day. So, what about this protected worksheet?

Here are two ways to share with you, and it is recommended to keep them.

Method for directly modifying file information

VBA skips password protection.

These two methods are only applicable to password cracking of worksheets.

Modify the file directly

Change Excel file to rar file format (change the suffix name of Excel file to. RAR suffix).

Open the compressed package and find the file XL \ worksheets \ worksheet name.xml.

Open the file with Notepad and delete it.

Paper Protection .............../> Part and save it.

Modify the suffix of the compressed package to. Xlsx file.

VBA Skip Protection Password

In the Protected Sheet tab, right-click and select View Code from the menu.

In the VBA editor, enter the following code:

Sub-crack ()

ActiveSheet。 Protect drawing object: =True, content: =True, allow filtering: =True.

ActiveSheet。 Protect drawing object: =False, content: =True, allow filtering: =True.

ActiveSheet。 Withdraw protection

End joint

Run this code to crack the protection secret.