King Lhen
asked on
Excel
I have excel sheet with 30 sheets. All the sheet tabs don't fit in one row. Can I view in two rows.
No but you can click the sheet navigation buttons in the bottom-left-hand corner of the workbook.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also, if you right-click the navigation buttons...I never knew that.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Alternative vba that will also hide other sheets
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim ws As Worksheet
If Target.Column <> 1 And Target.Row > 30 Then Exit Sub
ShtName = Target.Value
On Error GoTo Finish
For Each ws In ActiveWorkbook.Worksheets
If ws.Name <> ShtName And ws.Name <> "Index" Then
ws.Visible = xlSheetHidden
Else
ws.Visible = xlSheetVisible
End If
Next ws
Sheets(ShtName).Select
Range("A1").Select
Finish:
Cancel = True
End Sub