Freezing a row

Guy Cohen · Jan 27, 2004

Hi all.
I am using VB6 to generate an EXCEL report.
I would like to set "Window->Freeze panes" to row number 1 by code.
How do I do that?
TIA
Guy

Don Guillett · Jan 27, 2004

Have you tried the macro recorder? A good way to learn

Guy Cohen · Jan 27, 2004

No I have not
I am a newbie

BTW- If possible please teach me how to do it from VB

Guy

Tom Ogilvy · Jan 27, 2004

vb or Excel VBA would be the same

Activesheet.rows(2).Select
ActiveWindow.FreezePanes=True