Completely hide the Excel2007 document sheet

Because of the job requirements, some Excel worksheets We don't want people who participate in data entry to see that the general hidden worksheet is done by clicking the "format → visibility → hide and unhide → hidden sheets" series of actions. But the level of this approach is a bit too simple to deal with "rookie". If someone follows the steps above and chooses the Unhide sheet option, the hidden files are exposed.

Next, I'll introduce you to a more thorough way of hiding: Just enter the code "worksheets" (sheet name) in the "Workbook_Open" event in the current workbook. Visible = 2 ", you can completely hide the specified sheet, you need to display the worksheet when the" property "value from" 2 "to" 1 "can be.