View Single Post
  #3  
Old October 8th, 2009, 03:26 PM posted to microsoft.public.excel.misc
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Multiple Rows of Tabs?

Not possible.

If you click on one of the sheet navigation arrows you will get a list of 15
sheets and "more"

You can build a Sheet Navigation Toolbar as per Dave Peterson'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

On Thu, 8 Oct 2009 06:51:02 -0700, M.Boone
wrote:

Is it possible to have multiple rows of worksheet tabs? I have a file which
when finished will have a great many worksheets and hate having to scroll or
right-click to change between them.