Change color of active cells
 

Does anyone know if there is a way to change the color of active cells?

Change color of active cells
 

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.
--
Gary''s Student
gsnu200711