vba code needed for filling a row when a cell is selected that row

[bamaisgreat]

I have had to cut off my row and column headers due to a monitor only being 13" wide. If possible I need to see if there is code that can be inserted into the sheet that will simply fill that entire Row yellow when there is a cell selected in that Row.When another Row is selected it will fill it yellow and return the previously selected one back to no fill.... Thanks as always

 

[Pitchblend]

Are you set on VBA code? What if you simply split the windo and freeze panes? That way column and row headers remain visible when you scroll through the worksheet.

My daughter goes to Troy State.

 

[bamaisgreat]

yes i really need the code to do it for me. I think i may can use conditional formatting but I havent found the right formula.. Troy State is a awesome college, I had a family member that went there........

 

[Pitchblend]

Try this code by pasting it in the worksheet module. It doesn't have the functionality you asked for, but it should be close.

The code highlights the row if you double click in column A. To turn the highlighting off, you must double click column A again.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
With Target
Dim rng1 As Range
If .Row < 3 Or .Column > 1 Then Exit Sub
Set rng1 = Target.EntireRow

If rng1.Interior.ColorIndex = 6 Then
rng1.Interior.ColorIndex = 0
Else
rng1.Interior.ColorIndex = 6
End If

Cancel = True
End With
End Sub

 

[bamaisgreat]

Works good , I think I can work with that.I noticed you had a color index=6, were is that index located on a computer? Thanks

 

[Pitchblend]

I found the right color index by trial and error. Sorry!

There are other ways of setting the color. I think the statment below works(not tested)

Range.Interior.Color = RGB(0,0,0)

Excel has predefined colors that are enumerated, e.g; rgbAqua. Search RGB in the object browser.