Is it possible to change the color of worksheet tabs? (SOLVE

[phantom1975]

I'd like to color code the tabs in a workbook. Is that possible?

_________________
The only dumb question is the one that isn't asked. Pass on what you have learned.
This message was edited by phantom1975 on 2002-10-29 15:52

 

[Haluk]

On 2002-10-28 15:12, phantom1975 wrote:
I'd like to color code the tabs in a workbook. Is that possible?

including XL9 (Office2000) this feature is not available, even with VBA codes you can not change it ( as far as i know). But; if you are using OfficeXP you are lucky, you can do that ( but how.....i don't know, i'm not using OfficeXP)

 

[B_2]

Left Click on SHEET1/2/3 TAB and you will get the option to change the colour...

I think this is what your asking..

 

[Richie(UK)]

Hi phantom,

Check out this link to Ivan's site:

http://xcelfiles.homestead.com/Excel01.html

HTH

 

[Dejan]

Hi

Sheets("Sheet1").Select
ActiveWorkbook.Sheets("Sheet1").Tab.ColorIndex = 3' 3 = red colour