View Full Version : Solved: Whole row becomes shaded / highlighted when selected
BENSON
04-12-2007, 10:56 PM
Can Malcoms code seen below from a previous post be altered to also shade/ highlight the entire row say light grey
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Font.Bold = False
Target.EntireRow.Font.Bold = True
End Sub
THKS
geekgirlau
04-12-2007, 11:25 PM
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Font.Bold = False
Target.EntireRow.Font.Bold = True
Target.EntireRow.Interior.ColorIndex = 15
End Sub
BENSON
04-12-2007, 11:29 PM
MANY THANKS
Bob Phillips
04-13-2007, 01:20 AM
Don't forget to clear last time
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlColorIndexNone
Cells.Font.Bold = False
Target.EntireRow.Font.Bold = True
Target.EntireRow.Interior.ColorIndex = 15
End Sub
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.