WORKSHEET TABS

[Guest]

How do I change the font/fill color of Excel 2000 worksheet tabs?

 

[Harald Staff]

You can't -they follow Windows. (So change some Windows setting and they'll
all change, I suspect that's not what you want). Upgrade to XP or 2003 for
colored tabs.

HTH. Best wishes Harald

 

[Frank Kabel]

Hi
not possible. Excel 2002 introduced this feature

 

[Myrna Larson]

Assuming you mean different colors for different tabs, I believe that feature
was added in XL-XP, i.e. 2002. If you right-click on a tab and the feature is
available, it'll be on the menu. If you don't see it, you don't have it.

On Tue, 12 Oct 2004 12:41:06 -0700, "worksheet tabs" <worksheet

 

[Terry]

I run win98se OS with MS-Office XP Pro installed, and works a
treat...including a TAB color option.

Terry

 

[David McRitchie]

As the others have indicated to BOTH of your postings, the feature
was added in Excel 2002. Please post only once and wait for your answers
to roll in, which they actually did before you posted the second time. Half an
hour is very short time to have waited for someone else to be answering your
question. A day or two would be more appropriated and work on something else.

However, I can hardly see moving up to Excel 2002 for something minor
like worksheet tab color, which really isn't going to gain you much of anything.
There are better things that you can do with the worksheet tabs such as
sort the worksheet tabs see SortALLsheets macro in
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#sortallsheets
and comment about color sheet tabs in
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs

You can rename some of your worksheetnames so that sorting will keep
groups of sheets together. i.e. k.FunctKeys, k.ShortCutKeys -