| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Freezing | Excel Discussion (Misc queries) | |||
| Freezing a row | Excel Worksheet Functions | |||
| Filter Freezing | Excel Worksheet Functions | |||
| Freezing | New Users to Excel | |||
| freezing a row | Setting up and Configuration of Excel | |||
Linear Mode
