Quickly Tab Selection
hi, Mickky !
I am using Excel 2003 and i wondered if there was a way to quickly select the tab i needed
within a workbook where there are over 40 tabs.
I appreciate i can right click on the scroll arrows but this opens up a box
whereby i can view only a small seelction of the tabs...
i then have to select more sheets and then scroll to slect the one i require.
Is there a way that the entire list is viewable and therefore quicker?
not directly (I guess), but you could assign a shortcut to a macro like...
Sub myShList()
With Application.CommandBars("workbook tabs").Controls(16)
If Right(.Caption, 3) = "..." Then .Execute Else .Parent.ShowPopup
End With
End Sub
hth,
hector.
|