D
Don
Is there a way to change the color of the display tab on a worksheet in
Excel?
Excel?
G
Gord Dibben
Only in Excel 2002 and 2003.
Right-click on sheet tab and "Tab Color".
Gord Dibben Excel MVP
Right-click on sheet tab and "Tab Color".
Gord Dibben Excel MVP
P
Peo Sjoblom
Excel 2002 onwards..
D
Don
Thanks everyone!
Since I have MS Excel 2000, no wonder I couldn't find it!!
Since I have MS Excel 2000, no wonder I couldn't find it!!
D
David McRitchie
Hi Don,
Even though you do not have Excel 2002 or later there are things you can
do to organize your tabs that probably make a lot more sense than color.
I believe the normal reason in wanting to color tabs is to provide an organization to them.
You can sort sheet tabs with a macro. You can enhance your sorted arrangement
by preceding the sheet tab with some less conspicuous small letters. i.e.
k.FunctKeys, k.ShortCutKeys
More information on alternatives in ....
Changing the Colors of Worksheet Tabs (#tabs)
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs
Even though you do not have Excel 2002 or later there are things you can
do to organize your tabs that probably make a lot more sense than color.
I believe the normal reason in wanting to color tabs is to provide an organization to them.
You can sort sheet tabs with a macro. You can enhance your sorted arrangement
by preceding the sheet tab with some less conspicuous small letters. i.e.
k.FunctKeys, k.ShortCutKeys
More information on alternatives in ....
Changing the Colors of Worksheet Tabs (#tabs)
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs
D
Don
Thanks for the hints David!
This whole exercise was the result of seeing colored tabs somewhere and then
having some time to hack on my machine. I had gone down the "right-click"
path, but it didn't find anything related to color. Not surprising since I
have Excel 2000. Then I thought it might be some VBA magic and tried some
things there. But, as you show in the URL you posted, the property (both in
"right-click" and VBA!) is available in Excel 2002 and greater.
Maybe time for an upgrade!
Don
This whole exercise was the result of seeing colored tabs somewhere and then
having some time to hack on my machine. I had gone down the "right-click"
path, but it didn't find anything related to color. Not surprising since I
have Excel 2000. Then I thought it might be some VBA magic and tried some
things there. But, as you show in the URL you posted, the property (both in
"right-click" and VBA!) is available in Excel 2002 and greater.
Maybe time for an upgrade!
Don