[RESOLVED] Excel Automation Set a Fixed Row

[RobCrombie]

I am automating Excel from a VB6 program.
I am writing the Column Headers into Row1
I have managed to color them Grey (Would be nice if I could color the whole line, instead of the 10 Columns I have written Header Names to. But that was not my main question).
My question is -
How can I send the instruction for Row 1 to be 'Fixed' ?
(Is 'Fixed' the correct expression ?, as Googling was not a great success)
The end result should be that Row 1 will remain visible, even when the user goes scrolling down the Rows.

Thanks,
Rob

[Jrogers]

for whole column to be grey

objExcel.Rows(1).Interior.ColorIndex = 15

To freeze the top row

    With ActiveWindow
        .SplitRow = 1
        .FreezePanes = True
    End With

[RobCrombie]

Both questions are now resolved
Thank you for quick and informed response.

Rob