Worksheet Tab Direction

[Flowerly]

Microsoft Office 2007 which has a lot of updated features - since we are not
able to move the tabs from the bottom of the worksheet, is there a way to
change the alignment (orientation) of the tabs so that they are angled?
Basically, I would like to angle them counterclockwise so that more are
visable. Is this possible?

 

[Dave Peterson]

Nope.

But Ron de Bruin has an addin at Debra Dalgleish's site that you may like--if
you're concerned about navigating sheets.

http://contextures.com/xlToolbar01b.html

 

[Gord Dibben]

You cannot change the orientation of the tabs.

Here are 3 alternatives.

You can right-click on the sheet navigation arrows and select from 15 sheets
or "more sheets".

Or 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..............my personal choice for a single button on a Toolbar.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP