Highlighting tabs with macro based on a check box in a cell

[Johnny Thunder]

Hello,

I am trying to have three check boxes next to a drop down that shows (Check boxes)

Viewed = B9 Light yellow
Pending =C9 Red
Completed =D9 Green

And once one of the boxes is checked the tab will change colors.

any ideas?

Thanks guys!

 

[machopicho]

I did not understand very well what your objective.
However the code that runs the tab color change is:

Private Sub CheckBox1_Change()
If CheckBox1 = True Then
ActiveSheet.Tab.Color = 255 'red color
Else
ActiveSheet.Tab.Color = xlNone
End If
End Sub

 

[somnath_it2006]

You should use the Option buttons for this:

Private Sub Completed_Change()
    
    If Completed.Value = True Then
        
        With ActiveSheet.Tab
            .Color = 222222
            .TintAndShade = 0
        End With
    
    End If
    
End Sub

Private Sub Pending_Change()
    If Pending.Value = True Then
        
        With ActiveSheet.Tab
            .Color = 3333333
            .TintAndShade = 0
        End With
    
    End If
End Sub


Private Sub Viewed_Change()
    
    If Viewed.Value = True Then
        
        With ActiveSheet.Tab
            .Color = 5287936
            .TintAndShade = 0
        End With
    
    End If
    
End Sub

 

[Johnny Thunder]

Where would I enter this Macro? I am using Excel 2007? Would it just be a new macro? Cause I entered it in and nothing happens? Please help?