Tab colours

  • Thread starter Thread starter Francis Hookham
  • Start date Start date
F

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
 
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
 
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
 
Back
Top