Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamically setting worksheet tab colors
How do I make the worksheet tab color be the same as the color of a cell in
another worksheet? Thx for your help, John |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamically setting worksheet tab colors
Sub colortabbasedoncellvalue()
Sheets("Sheet22").Tab.ColorIndex = _ Sheets("sheet25").Range("d3").Interior.ColorIndex End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "John" wrote in message ... How do I make the worksheet tab color be the same as the color of a cell in another worksheet? Thx for your help, John |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamically setting worksheet tab colors
Looks good, but where do I put this routine?
"Don Guillett" wrote: Sub colortabbasedoncellvalue() Sheets("Sheet22").Tab.ColorIndex = _ Sheets("sheet25").Range("d3").Interior.ColorIndex End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "John" wrote in message ... How do I make the worksheet tab color be the same as the color of a cell in another worksheet? Thx for your help, John |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamically setting worksheet tab colors
Understand. And this works fine if I execute the macro after changing the
color of the cell. But I want the change to take place as soon as I change the color of the cell. Sooo, it seems to do what I wan if I place the VB routine you suggested in the Sheet25(Sheet25) area with a header of Private Sub Worksheet_SelectionChange(ByVal Target As Range), rather than in Module1. Now whenever I navigate way from the cell after changing its color, the tab on the corresponding sheet changes. Is there a better solution? I'm pretty green in the VB world. Thx for your help, John "Don Guillett" wrote: It's a macro. Put in a module and execute it. -- Don Guillett Microsoft MVP Excel SalesAid Software "John" wrote in message ... Looks good, but where do I put this routine? "Don Guillett" wrote: Sub colortabbasedoncellvalue() Sheets("Sheet22").Tab.ColorIndex = _ Sheets("sheet25").Range("d3").Interior.ColorIndex End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "John" wrote in message ... How do I make the worksheet tab color be the same as the color of a cell in another worksheet? Thx for your help, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet formatting (fill colors & text colors) disappeared | Excel Discussion (Misc queries) | |||
Creating a Dynamically Linked Worksheet | Excel Worksheet Functions | |||
Setting Range Dynamically | Excel Discussion (Misc queries) | |||
MY 2003 Excel does not show cell colors. Solution? Setting? | Excel Discussion (Misc queries) | |||
Setting colors of results in a column | Excel Discussion (Misc queries) |