How do I have a cell highlight when selected?
Typo patrol.........I found one instead of creating one<g
Make that.........Right-click on the worksheet tab and paste the code.
Gord Dibben MS Excel MVP
On 2 Oct 2006 13:16:12 -0700, "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
|