Excel 2007 Document Worksheets completely hiding method

Because of the job requirements, some Excel 2007 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.

Here's a more thorough way to hide: Just enter the code "worksheets" (worksheet name) in the event "Workbook_Open" (alt+f11, double-click ThisWorkbook selection) 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. Through the above methods, you can realize the complete hidden work table.

Note : More wonderful tutorials Please pay attention to the triple computer Tutorials section, triple Office group: 185219299 welcome you to join