Tab colours

[Francis Hookham]

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

 

[paul.robinson]

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

 

[JE McGimpsey]

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

 

[ChelseaWarren]

Where do you put that statement?

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

 

[Francis Hookham]

Many thanks JE and Paul - just the job!

Francos Hookham