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

Below code Freezes Panes at Row1, Coloumn1:

Sub PaneFreezer()
ThisWorkbook.Sheets("Sheet1").Activate
ActiveWindow.FreezePanes = False 'If previously frozen at, unfreeze
first
ThisWorkbook.ActiveSheet.Cells(2, 2).Select
ActiveWindow.FreezePanes = True
End Sub

Sharad
"Rohit" wrote in message
...
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

This doesn't work with office XP spreadsheet control

"Sharad Naik" wrote in message
...
Below code Freezes Panes at Row1, Coloumn1:

Sub PaneFreezer()
ThisWorkbook.Sheets("Sheet1").Activate
ActiveWindow.FreezePanes = False 'If previously frozen at, unfreeze
first
ThisWorkbook.ActiveSheet.Cells(2, 2).Select
ActiveWindow.FreezePanes = True
End Sub

Sharad
"Rohit" wrote in message
...
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