software

In complex Excel spreadsheets, the current single line for worksheet tabs is
restrictive.

Instead, please consider including a second or third row option that will
allow for numerous worksheets to be accessible at one time.

This will save time instead of having to use the |lt; lt; gt; gt;| buttons.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc


If you right click over the buttons you can pick from a larger set of
Worksheets, but not all of them. You can pick more sheets which opens a
dialogue box that allows you to pick the sheet you want.--
drewlake
------------------------------------------------------------------------
drewlake's Profile: www.excelforum.com/member.php...oamp;userid=30349
View this thread: www.excelforum.com/showthread...hreadid=504038How about trying this

I add a drop-down to the Formatting toolbar, and in ThisWorkbook, I setup up
the toolbar buton and populate it soPrivate Workbook_Open()
With Application.CommandBars(quot;Formattingquot;)
With .Controls.Add(Type:=msoControlDropdown, temporary:=True)
.Caption = quot;SheetGotoquot;
.OnAction = quot;GotoSheetquot;
End With End With
End SubPrivate Sub Workbook_Activate()
Dim i As LongWith Application.CommandBars(quot;Formattingquot;).Controls(quot;Sh eetGotoquot;)
.Clear
For i = 1 To Wb.Sheets.Count
.AddItem Wb.Sheets(i).Name
Next i
.ListIndex = 1
End With
End SubIn a standard code module I add this macro to actiavte the sheetPrivate Sub GotoSheet()
With Application.CommandBars.ActionControl
ActiveWorkbook.Sheets(.Text).Activate
End With
End Sub--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Peter Grossquot; lt;Peter gt; wrote in message
...
gt; In complex Excel spreadsheets, the current single line for worksheet tabs
is
gt; restrictive.
gt;
gt; Instead, please consider including a second or third row option that will
gt; allow for numerous worksheets to be accessible at one time.
gt;
gt; This will save time instead of having to use the |lt; lt; gt; gt;| buttons.
gt;
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt;
www.microsoft.com/office/comm...id=34febb21-51
6c-43e3-9d5a-c945b090cdfeamp;dg=microsoft.public.excel.misc
Peter-
Did you know you can display multiple tabs on screen simultaneously?
With your sprdsht open, click gt;Window gt;New. Notice the filename (upper
left corner) now includes a :1 or :2 suffix, indicating which window is
visible. Click gt;Window gt;Arrange and select one of the display options
(I prefer horizontal) to show both windows at once. Select window 1
and indicate which tab to display; select window 2 and indicate another
tab to display. A change made to one window is made to the other
window, so you can see the results of a change as it ripples throughout
the sprdsht.quot;Peter Grossquot; wrote:

gt; In complex Excel spreadsheets, the current single line for worksheet tabs is
gt; restrictive.

I have a worksheet with over 60 tabs. A summary worksheet pulls data from
all of the other worksheets. I solved my navigation problem by putting a
hyperlink for each of the other tabs on the summary page. On all the other
worksheet , there is a hyperlink back to the summary worksheet.

quot;Jasonquot; wrote:

gt; quot;Peter Grossquot; wrote:
gt;
gt; gt; In complex Excel spreadsheets, the current single line for worksheet tabs is
gt; gt; restrictive.
gt;
gt; I have a worksheet with over 60 tabs. A summary worksheet pulls data from
gt; all of the other worksheets. I solved my navigation problem by putting a
gt; hyperlink for each of the other tabs on the summary page. On all the other
gt; worksheet , there is a hyperlink back to the summary worksheet.
gt;

This do the trick when navigating data sheets, how ever when working this
summary work sheet and writing formulas containting cells from multiple
worksheets there is just no easy way to use that method for entering 'name of
tab 87'!C2 for instance.

I'd still love to be able to use multiple rows of work sheet tabs or to
shrink the font and/ or turn the tab names 90 degrees for easy access when
working formulas.

Have you tried right-clicking on the group of arrows to the left of the
tabs?quot;Antonquot; gt; wrote in message
...
gt;
gt;
gt; quot;Jasonquot; wrote:
gt;
gt;gt; quot;Peter Grossquot; wrote:
gt;gt;
gt;gt; gt; In complex Excel spreadsheets, the current single line for worksheet
gt;gt; gt; tabs is
gt;gt; gt; restrictive.
gt;gt;
gt;gt; I have a worksheet with over 60 tabs. A summary worksheet pulls data from
gt;gt; all of the other worksheets. I solved my navigation problem by putting a
gt;gt; hyperlink for each of the other tabs on the summary page. On all the
gt;gt; other
gt;gt; worksheet , there is a hyperlink back to the summary worksheet.
gt;gt;
gt;
gt; This do the trick when navigating data sheets, how ever when working this
gt; summary work sheet and writing formulas containting cells from multiple
gt; worksheets there is just no easy way to use that method for entering 'name
gt; of
gt; tab 87'!C2 for instance.
gt;
gt; I'd still love to be able to use multiple rows of work sheet tabs or to
gt; shrink the font and/ or turn the tab names 90 degrees for easy access when
gt; working formulas.