viewing multiple worksheet tabs

[mister harabi]

hello.
can someone tell me if there is an alternative to viewing multiple
worksheet tabs in an excel workbook. with multiple sheet tabs only
displayed at the bottom of the workbook, it is difficult to move easily
between sheets. is there an option to view sheets in a "menu" style or
"table of contents" style somewhere else on the page?
thank you
mister harabi

 

[Bernard Rey]

mister harabi:

can someone tell me if there is an alternative to viewing multiple
worksheet tabs in an excel workbook. with multiple sheet tabs only
displayed at the bottom of the workbook, it is difficult to move easily
between sheets. is there an option to view sheets in a "menu" style or
"table of contents" style somewhere else on the page?

A right-clic (control-clic) on the arrows at bottom left (next to the sheet
tabs) will display a menu listing the visible sheets in the current workbook

 

[JE McGimpsey]

hello.
can someone tell me if there is an alternative to viewing multiple
worksheet tabs in an excel workbook. with multiple sheet tabs only
displayed at the bottom of the workbook, it is difficult to move easily
between sheets. is there an option to view sheets in a "menu" style or
"table of contents" style somewhere else on the page?

In addition to the control that Bernard mentioned, you can use the Sheet
List control to bring up a dialog with a menu of worksheets in the
active workbook.

The control isn't in the Customize Toolbars dialog, so run this macro to
create a custom toolbar with a button that brings up the dialog

Public Sub AddSheetSelectionControlBar()
With CommandBars.Add(Name:="MyCustomBar", Temporary:=True)
With .Controls.Add(Type:=msoControlButton, Id:=957)
.FaceId = 461
.TooltipText = "Sheet List"
End With
.Visible = True
End With
End Sub

You can then select Tools/Customize/Customize Toolbars/Menus... and drag
the control to whatever toolbar you wish.