Tab Organization

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

I am using Excel 2000, and I often use many worksheets in
one workbook. Is there any way to organize these tabs
other than just scrolling through? Is there a way to put
them into sub-groups, or even show more than what fits
along the bottom of the screen?
 
or even show more than what fits
along the bottom of the screen?
Click to expand...

Right-click at the "vcr-like" array of buttons at the bottom left corner
This will pop-up a menu which gives easy selection of any sheet
 
Dave Peterson's provided an improved answer in same thread 2002-10-29
http://www.google.com/[email protected]

which will bring up only *one* of the two lists, you don't want to
look at both lists.
The 1st one is the extended list so you don't have to choose "more sheets"
but it fails for something like under 10 sheets, so the error recovery will bring
up the shorter list that you get with right click on the sheet navigation keys.

Sub SheetList_CP()
'Chip Pearson, 2002-10-29, misc., %23ByZYZ3fCHA.1308%40tkmsftngp11
'Dave Peterson, same date/thread, 3DBF0BA8.4DAE9DA0%40msn.com
On Error Resume Next
Application.CommandBars("Workbook Tabs").Controls("More Sheets...").Execute
If Err.Number > 0 Then
Err.Clear
Application.CommandBars("Workbook Tabs").ShowPopup
End If
On Error GoTo 0
End Sub

The request in that thread was from someone who did not want
to use the mouse, preferring keyboard shortcuts that could be
assigned to a macro.
 
Back
Top