 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / February 2006viewing multiple worksheet tabs
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 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  SignatureBernard Rey - Toulouse / France MVP - office:macintosh http://faq.office.macintosh.free.fr > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.