I am trying to create a macro that will toggle on and off. It will highlight the active cell upon its selction. I can set the code to whatever color I want, but I would like it to use the color set on the menu bar. Does anyone know how to do this?
My macro set with a random color
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) ActiveCell.Select With Selection.Interior .ColorIndex = 7 End With End Sub
I will add the toggle later.