| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Freeze Panes
How can I freeze panes at runtime?
I am using MS Spreadsheet control. I am using following code to activate the cell and freezing the pane Spreadsheet1.ActiveCell.Offset(3, 4).Select Spreadsheet1.ActiveWindow.FreezePanes = True It seems that cell is getting activated and the first cell of the sheet is (3,4) cell, so freezing pane is not working here. Please let me know if anybody has any ideas. Regards, Rohit Kumar |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
| FREEZE PANES | Excel Discussion (Misc queries) | |||
| Freeze Panes | Excel Discussion (Misc queries) | |||
| Not quite "Freeze Panes"..... | Excel Discussion (Misc queries) | |||
| Freeze Certain Panes | Excel Programming | |||
Threaded Mode
