Hidden Excel worksheet You don't want to cancel it.

In Excel, you typically hide worksheets by doing the following:

Activate the worksheet that you want to hide into the current worksheet, and then do a "format → sheet → hide" command to hide it.

The hidden worksheet, by executing the format → sheet → unhide command, opens the Unhide dialog box (Figure 1), selects the name of the worksheet that needs to be displayed, and clicks OK to display it.

Today, I'm going to show you a way to hide a worksheet, a worksheet that is hidden by others.

1, start Excel, open the corresponding workbook document.

2, press the ALT+F11 key combination into the VBA edit state (Figure 2).

3, press the F4 function key, expand the Properties window (see Figure 3).

4. Select the worksheet (such as "Sheet3") that you want to hide in the corresponding workbook, and then in the Properties window below, locate the "Visible" option, click the Drop-down button to the right, and in the Drop-down list that appears, select the "0-xlsheetveryhidden" option.

Note: In each workbook document, at least one worksheet is not hidden.

5, and then execute the tool →vbaproject Properties command, open the Vbaproject-Engineering Properties dialog box (Figure 3).

6, switch to the "Protection" tab, select the "Lock project when viewing" option, and enter a password to determine return (see Figure 3).

7, exit the VBA edit State, save the workbook document, hide the implementation.

After this setup, we found that the "format → worksheet → unhide" command is grayed out and cannot be executed, and if you want to modify the property through the VBA editing window, you will find that you need to provide a password (Figure 4) and you cannot unhide the password without knowing it.