VBA Cell Color Won't stick

[dshafique]

Hello Everyone, I recorded a macro to make specific cells red and the text white. when I run it before saving, it turns red and makes the text white. however, after saving it or sending it to someone, it wont change the format of their cells. Any reason why that would be so?

ActiveSheet.ListObjects("dTable").Range.AutoFilter Field:=8, Criteria1:= _
        "MISMATCH"
    With Selection.Interior
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
        .Color = 192
        .TintAndShade = 0
        .PatternTintAndShade = 0
    End With
    With Selection.Font
        .ThemeColor = xlThemeColorDark1
        .TintAndShade = 0
    End With

 

[JoeMo]

Possibly, the cells you expect to change are not selected when the macro is run. You might want to change "Selection" to a specific range before sending the workbook to others.

 

[dshafique]

Actually, just figured out, the reason was because of the

.tintAndShade = 0

line. commented it out, and it worked.