| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I customise colours used in charts and keep those colours. | Charts and Charting in Excel | |||
| How to save one of the MORE COLOURS in the THEME COLOURS? | Excel Discussion (Misc queries) | |||
| Colours | Excel Discussion (Misc queries) | |||
| Colours | Excel Discussion (Misc queries) | |||
| Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) | |||
Linear Mode
