Hello. I know this is a basic question, but it is actually a roadblock for me in trying to learn VBA. I did the basic code, closed my worksheet, reopened worksheet, clicked Enabled Macros, but nothing happens in my worksheet when I change something. Is there a special way to run a private macro?
Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
'Sets all rows to no color and then to yellow on change in cells
Rows.Interior.ColorIndex = xlColorIndexNone
Target.EntireColumn.Interior.ColorIndex = 36
Target.EntireRow.Interior.ColorIndex = 37