Hide a worksheet when workbook is opened

[bt2086]

How to hide a worksheet when workbook is opened?

 

[martindwilson]

hide it before you close it?

 

[bt2086]

I have about 8 worksheets, and I'd like to have some of them to be hidden from the beginning and remain hidden

 

[martindwilson]

they must be open at some point! hide them then make them very hidden

1. Press Alt-F11 to display the Visual Basic Editor
2. in the Project window, double-click Microsoft Excel Objects and select the sheet to hide.
3. Press F4 to display the Property box
4. Set the sheet's Visible property to xlSheetVeryHidden.

To unhide the sheet, repeat these step, but set the Visible property to xlSheetVisible.
or
http://www.dailydoseofexcel.com/archives/2006/07/20/very-hidden-worksheets/

 

[bt2086]

Thank you! It works

 

[Michael M]

You could also use

Sub Workbook_Open()
Sheets("Sheet1").Visible = False 'change sheet name to suit
End Sub

PAste this into the "This Workbook" module in the VBA Project