TAB color

[clvestin]

Off subject question
How do you set the sheet Tab color ?? ie from Excel alone

[austenr]

Right click on the tab and select tab color.

[mvidas]

austenr is correct, but I'd like to add that this feature wasn't added to excel until version 2002. The color can't be changed (afaik) in prior versions.
Matt

[austenr]

Thanks mv. Forgot to include that. Does this solve your problem?

[MWE]

austenr is correct, but I'd like to add that this feature wasn't added to excel until version 2002. The color can't be changed (afaik) in prior versions.
Matt
I do not believe I have ever seen a spreadsheet with colored tabs; but I have never upgraded to V2002 or XP or whatever, so that explains it.

I suspect that colored tabs would be pretty useful.

[austenr]

try this:


ActiveWorkbook.Sheets("RelevantName").Tab.ColorIndex = relevantcolourIndex

[clvestin]

ok-thx-running 2000 on the home unit-no wonder i was having problems

[Zack Barresse]

Actually, you can change the color in versions below 2002! :yes Just use a little API.

Check out the work Ivan Moala has done here: http://www.xcelfiles.com/Excel01_02.html