Many sheets in a file - can they be shown in more rows
 

Working with manu sheets in the same Excel-file, I'm loosing the overview a
bit when some of the sheets can be shown - can the tags/sheetnames be shown
in more than one row?
--
Best from
Bjarne

Many sheets in a file - can they be shown in more rows
 

Hi Bjarne

Maybe you like this
http://www.contextures.com/xlToolbar01.html


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Bjarne Krog" wrote in message ...
Working with manu sheets in the same Excel-file, I'm loosing the overview a
bit when some of the sheets can be shown - can the tags/sheetnames be shown
in more than one row?
--
Best from
Bjarne

Many sheets in a file - can they be shown in more rows
 

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" to select from.

Or you can build a Navigation Toolbar as per Dave's code on Debra
Dalgleish's site to which Ron pointed you.

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

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP

On Mon, 20 Oct 2008 03:58:02 -0700, Bjarne Krog
wrote:

Working with manu sheets in the same Excel-file, I'm loosing the overview a
bit when some of the sheets can be shown - can the tags/sheetnames be shown
in more than one row?

Many sheets in a file - can they be shown in more rows
 

Hi Gord - thx for info.

--
Best from
Bjarne


"Gord Dibben" skrev:

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" to select from.

Or you can build a Navigation Toolbar as per Dave's code on Debra
Dalgleish's site to which Ron pointed you.

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

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP

On Mon, 20 Oct 2008 03:58:02 -0700, Bjarne Krog
wrote:

Working with manu sheets in the same Excel-file, I'm loosing the overview a
bit when some of the sheets can be shown - can the tags/sheetnames be shown
in more than one row?

Many sheets in a file - can they be shown in more rows
 

Hi Ron - thx for the info.

--
Best from
Bjarne


"Ron de Bruin" skrev:

Hi Bjarne

Maybe you like this
http://www.contextures.com/xlToolbar01.html


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Bjarne Krog" wrote in message ...
Working with manu sheets in the same Excel-file, I'm loosing the overview a
bit when some of the sheets can be shown - can the tags/sheetnames be shown
in more than one row?
--
Best from
Bjarne