How to hide the worksheet of excel2007

Iamlaosong

At work, we will encounter some Excel worksheet that users do not want to see. For example, I have a standalone examination system, one of which is all the questions and standard answers, in this case, you need to hide the worksheet. You can use the "worksheet" option in the "format" menu to hide a worksheet, but select the "unhide" command.

There is one way to hide the excel2007 Worksheet: Enter the code "worksheets (" worksheet name ") in the" workbook_open "event in the current workbook "). visible = 2 "to completely hide the specified worksheet. However, this method requires saving the VBA code. If macro operations are prohibited, this hiding does not work.
In fact, you can run the program once. After running the program, you can delete the code and save the worksheet. From this point of view, why write a program and directly modify the attributes. The method is as follows:

1. Enter the VBA Development Environment: Choose "development tools"> "Visual Basic"

2. Select a worksheet to be hidden. The properties of the worksheet are shown below.

3. Click "visible" in the last attribute and select attribute value 2, as shown in

Save the file. When you need to display the worksheet, you can enter the development environment again and change the attribute value from "2" to "-1.

How to hide the worksheet of excel2007