Thread
:
Dynamically setting worksheet tab colors
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Dynamically setting worksheet tab colors
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 With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett