How do I make more than one row of sheet tabs

[Ron]

I have so many sheet tabs at the bottom of my work book that I would like to
make multiple rows. Is this possible?

 

[Gator]

Do you have to see them all the time or do you just want to jump from tab to
tab without scrolling...
Or, you might check out a previous question titled 'Workbook tabs'...do a
search.

 

[Gator]

the question was posted 9/7/06 by Dave
--
Gator

Do you have to see them all the time or do you just want to jump from tab to
tab without scrolling...
Or, you might check out a previous question titled 'Workbook tabs'...do a
search.

 

[Gord Dibben]

You cannot do that.

You can right-click on the navigation arrows at lower left end of sheet tabs bar
and get a list of 15 sheets and "more sheets".

O)r you can build a Navigation Toolbar as per Dave's code on Debra Dalgleish's
site.

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