How do I hide an Excel worksheet

How do I hide worksheets

In actual work, it is often necessary to hide some important worksheets, however, a lot of friends in the hidden worksheet, is the menu "format/worksheet/hidden" to complete, do not know how to hide the worksheet, for a few people who know Excel, is basically a fake, because we can also use the "Format/worksheet /unhide "to show it, so how do you really hide it? The method is simple, and the steps are as follows:

1. Select the menu "Tools/Macros/visual Basic Editor" command to open the Microsoft Visual Basic Program window and see on the left (Figure 1) the "Engineering" and "Properties" panels.

2. Select the worksheet you want to hide in the engineering panel and set the Visible property value to 2-xlsheetveryhidden in the Properties panel. (DYJ123. COM remind everyone if set to 0-xlsheethidden is general hide, you can still cancel it by formatting/sheet/unhide. )

3, select the "Tools/vbaproject Properties" command, open the "VBAProject Engineering Properties" dialog box, select the "Protection" tab, check "lock project when viewing", and set the password to view the project properties, click "OK" button (Figure 2).

4, press Ctrl+s to save the file, return to the Excel interface can see the worksheet has been hidden. The menu "format/sheet/unhide" is also in a gray state at this time. Even if someone knows this method, no password is also unable to display the hidden worksheet, quickly try it!