Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change tab colors via programming
I have created a calendar with separate sheets per week (so....52 sheets for
a year). I use conditional formatting to color the current day on the sheet but I would like to color the tab as well. I want the current days' tab to be yellow. I have tried several things but nothing works. Not sure where to put the code (right click the tab and "View Code" I think, but not sure). I want it to activate automatically. Is this possible? -- Bob R |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Change tab colors via programming
Colored tabs were introduced in Excel 2002 (XP). You can't change the
colors in earlier versions. To change a tab programmatically, use Worksheets("Sheet2").Tab.ColorIndex = 3 'red Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Mon, 5 Jan 2009 13:06:03 -0800, Bob wrote: I have created a calendar with separate sheets per week (so....52 sheets for a year). I use conditional formatting to color the current day on the sheet but I would like to color the tab as well. I want the current days' tab to be yellow. I have tried several things but nothing works. Not sure where to put the code (right click the tab and "View Code" I think, but not sure). I want it to activate automatically. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colors change from '07 to 03 in Excel | New Users to Excel | |||
Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
colors change magically | Excel Discussion (Misc queries) | |||
change colors | Setting up and Configuration of Excel | |||
macro used to change colors | Excel Worksheet Functions |