How do I have a cell highlight when selected?
"Carim" wrote:
Hi Rhonda,
Use the following code :
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6
End Sub
This code is to be inserted into the worksheet module ...
Left click on your worksheet tab
Select view
Paste the above code...
You are all set ...
HTH
Cheers
Carim
|