Tab colours
 

Any way of colouring the worksheet tabs and/or the type within them?

It's a bit academic since the same can be achieved with coloured icons on a
custom toolbar which select activate the required sheet. I just wondered if
it would be an easier way, if possible.

(I'm using XL 2002 but it will also have to run on Mac 2004)

Francis Hookham

Tab colours
 

Hi
Activesheet.Tab.Colorindex = 5

will colour the tab blue. I don't think you can get at the font in a
tab, but could be wrong about that.
regards
Paul

On May 9, 12:38 pm, "Francis Hookham" wrote:
Any way of colouring the worksheet tabs and/or the type within them?

It's a bit academic since the same can be achieved with coloured icons on a
custom toolbar which select activate the required sheet. I just wondered if
it would be an easier way, if possible.

(I'm using XL 2002 but it will also have to run on Mac 2004)

Francis Hookham

Tab colours
 

And note that it won't work cross-platform, so you'd have to use
conditional compilation:

#If Mac Then
'display toolbar
#Else
Activesheet.Tab.ColorIndex = 5
#End if



In article .com,
wrote:

Activesheet.Tab.Colorindex = 5

will colour the tab blue. I don't think you can get at the font in a
tab, but could be wrong about that.

Tab colours
 

Where do you put that statement?

" wrote:

Hi
Activesheet.Tab.Colorindex = 5

will colour the tab blue. I don't think you can get at the font in a
tab, but could be wrong about that.
regards
Paul

On May 9, 12:38 pm, "Francis Hookham" wrote:
Any way of colouring the worksheet tabs and/or the type within them?

It's a bit academic since the same can be achieved with coloured icons on a
custom toolbar which select activate the required sheet. I just wondered if
it would be an easier way, if possible.

(I'm using XL 2002 but it will also have to run on Mac 2004)

Francis Hookham

Tab colours
 

Many thanks JE and Paul - just the job!

Francos Hookham


"JE McGimpsey" wrote in message
...
And note that it won't work cross-platform, so you'd have to use
conditional compilation:

#If Mac Then
'display toolbar
#Else
Activesheet.Tab.ColorIndex = 5
#End if



In article .com,
wrote:

Activesheet.Tab.Colorindex = 5

will colour the tab blue. I don't think you can get at the font in a
tab, but could be wrong about that.