Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

To set the visible property to xlVeryHidden on ALL sheets in workbook

Sub xlVeryHidden_All_Sheets()     On Error Resume Next     Dim sh As Worksheet     For Each sh In Worksheets         sh.Visible = xlVeryHidden     Next End Sub