| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Color Tabs
I've been messing around trying to color tabs. Anybody have a suggestion.
SAM |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color Tabs
Samuel,
This can be done only in Excel 2002 and later. To change the color of the tab, right click the tab and choose Tab Color, or go to the Format menu, choose Sheet, then Tab Color. In VBA, this code will color the tab red: ActiveSheet.Tab.ColorIndex = 3 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Samuel Thomsen" wrote in message ... I've been messing around trying to color tabs. Anybody have a suggestion. SAM |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Color Tabs
Samuel,
If you mean the worksheet tabs, only possible in Excel XP. -- HTH Bob Phillips "Samuel Thomsen" wrote in message ... I've been messing around trying to color tabs. Anybody have a suggestion. SAM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color Tabs Over a Network | Excel Discussion (Misc queries) | |||
| Color Tabs | Excel Worksheet Functions | |||
| Color tabs? | Excel Discussion (Misc queries) | |||
| CANNOT COLOR MY WORKSHEET TABS, TAB COLOR NOT IN FORMAT | Excel Worksheet Functions | |||
| My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
Linear Mode
