change cell color based on a tab color
 

How do I change the color of a cell on one worksheet based on the color of a
different tab worksheet? Example. I have cell A3 on Worksheet 1, and I want
it to change based on the tab color of worksheet 3.

Thanks,

change cell color based on a tab color
 

Worksheets(3).Tab.ColorIndex

"Michael" wrote:

How do I change the color of a cell on one worksheet based on the color of a
different tab worksheet? Example. I have cell A3 on Worksheet 1, and I want
it to change based on the tab color of worksheet 3.

Thanks,

change cell color based on a tab color
 

Here is an example


Private Sub CommandButton1_Click()
Sheets(1).Select
Range("A1").Select
ActiveCell.Interior.ColorIndex = Worksheets(3).Tab.ColorIndex
End Sub

change cell color based on a tab color
 

you could add itas part of your worksheet_change or
worksheet_calculate or do you have any other forms buttons you use a
lot on the form.
Do you have any cells that change regularly llike totals or click
regularly that you can refer to or you could add a button..like update
all?