Link to home
Start Free TrialLog in
Avatar of King Lhen
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.
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

No but you can click the sheet navigation buttons in the bottom-left-hand corner of the workbook.
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Also, if you right-click the navigation buttons...
I never knew that.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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

Open in new window