ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Worksheet Tab Direction (https://www.excelbanter.com/excel-discussion-misc-queries/234701-worksheet-tab-direction.html)

Flowerly

Worksheet Tab Direction
 
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

Worksheet Tab Direction
 
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



Flowerly wrote:

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

Gord Dibben

Worksheet Tab Direction
 
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

On Tue, 23 Jun 2009 07:35:01 -0700, Flowerly
wrote:

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?




All times are GMT +1. The time now is 03:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com