Forum Discussion

GEEK_21's avatar
GEEK_21
Brass Contributor
May 27, 2023
Solved

Highlight the column header of the selected cell | Solved

Hello everyone I hope you are well. Just a small request, I have the file shown above and I would like to highlight the column header of the selected cell       Private Sub Workbook_Sheet...
  • HansVogelaar's avatar
    May 27, 2023

    GEEK_21 

    I don't really understand your code, but perhaps add the following line above the line that protects the sheet just before the end of the code:

    Sh.Cells(2, Target.Column).Interior.Color = RGB(255, 255, 0)

Resources