Hi Gord
I just can't get the Navigation Toolbar as per Dave's code on Debra
Dalgleish's site to work
http://www.contextures.on.ca/xlToolbar01.html

Using 2007 instructions
Would there be something you can think of that I'm not doing correctly

I'm missing the Sheet Navigator commands
1. The Sheet Navigator commands should appear at the far right of
the Home tab on the Ribbon..
2. Click the Select a Sheet command, to view a list of sheets in
the active workbook.
3. From the dropdown list, select a sheet, and that sheet will be
activated.

I also didn't use Ron de Bruin's Modify the XML to Add the Buttons
code as I didn't know what I was doing
--
Martin
©¿©¬


On Tue, 16 Dec 2008 12:46:34 -0800, Gord Dibben <gorddibbATshawDOTca
wrote:

This cannot be done.

Right-click on one of the sheet navigation arrows to get a 15 sheet listing
and "more".

Another option................................

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

On Tue, 16 Dec 2008 10:48:00 -0800, Raks <Raks @discussions.microsoft.com
wrote:

I have added many sheets in single workbook, how can i mahe the sheet tabs
veritical as i want them to appear on single screen