Tab Selection

[MickkyB]

I'm using Excel 2003 and wondered if there Is a quick way of selecting a tab where at least 40 tabs exist in a workbook.
i appreciate that i can select the scroll arrows but this shows a pop up whereby i have to select more sheets and then i have to scroll through the lsit to select the tab i require.
Is there a way to show all tabs in one window or some other quick option?

Thanks in advance
Mick


--------------= Posted using GrabIt =----------------
------= Binary Usenet downloading made easy =---------
-= Get GrabIt for free from http://www.shemes.com/ =-

 

[Héctor Miguel]

hi, MickkyB !

your hurry should never leave behind your patience ... (I guess)...
see your previous post

regards,
hector.

__ OP __

 

[Gord Dibben]

You can build a Navigation Toolbar as per Dave's code on Debra Dalgleish's
site. Sorts as well as navigates.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob Phillips.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP