Freezing a row
 

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

Freezing a row
 

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

--
Don Guillett
SalesAid Software

"Guy Cohen" wrote in message
...
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

Freezing a row
 

No I have not
I am a newbie :)
BTW- If possible please teach me how to do it from VB ;)
Guy

þþ"Don Guillett" ëúá áäåãòä
...
Have you tried the macro recorder? A good way to learn

--
Don Guillett
SalesAid Software

"Guy Cohen" wrote in message
...
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

Freezing a row
 

vb or Excel VBA would be the same

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

--
Regards,
Tom Ogilvy



Guy Cohen wrote in message
...
No I have not
I am a newbie :)
BTW- If possible please teach me how to do it from VB ;)
Guy

þþ"Don Guillett" ëúá áäåãòä
...
Have you tried the macro recorder? A good way to learn

--
Don Guillett
SalesAid Software

"Guy Cohen" wrote in message
...
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