92 votes18 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →Neil commented
Grouping of Worksheet tabs and the ability to define groupings by name would be a big improvement. I have used this macro which I expand upon/ change as needed.
Sheets("SHEET2").Visible = True
Dim sh As Worksheet
For Each sh In Worksheets
If sh.Name <> "SHEET1" And sh.Name <> "SHEET2" Then sh.Visible = xlSheetHidden