selected cells in yellow

[aoc]

Dear All,

what can I do if I want below code to run automatically for all workbooks I open. I attached the file.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6
End Sub
Private Sub Worksheet_Deactivate()
Cells.Interior.ColorIndex = xlNone
End Sub

[mikerickson]

You could move them to the Workbook_SheetChange and the Workbook_SheetDeactivate events in the ThisWorkbook code module.

[aoc]

Hi,

I tried but the cell does not change. I attached the file