Does anyone know if there is a way to change the color of active cells?
G Gary''s Student Mar 19, 2007 #2 Put the following in Worksheet code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = 0 Selection.Interior.ColorIndex = 6 End Sub REMEMBER; Worksheet code, not a standard module.
Put the following in Worksheet code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = 0 Selection.Interior.ColorIndex = 6 End Sub REMEMBER; Worksheet code, not a standard module.
