open Excel from Web: freeze panes so 1st row is always displayed at top?

[Mad Scientist Jr]

Is it possible to freeze panes in an OWC spreadsheet embedded in a
webpage?

None of my attempts seem to work...

Any help appreciated

'FREEZE PANES?
'attempt1

''objExcel.ActiveSheet.Rows(2).FreezePanes(OWC.SheetFreezePanesEnum.ssFreezeTop)
''objExcel.ActiveSheet.Cells(2, 2).select()

''objExcel.ActiveSheet.Cells.FreezePanes(OWC.SheetFreezePanesEnum.ssFreezeNone)

'attempt2
''objExcel.ActiveWindow.FreezePanes = True
''objExcel.ActiveSheet.FreezePanes = True

''objExcel.ActiveSheet.Cells.FreezePanes(OWC.SheetFreezePanesEnum.ssFreezeTop)

'objExcel.ActiveCell.FreezePanes(OWC.SheetFreezePanesEnum.ssFreezeTop)

'attempt3
'objExcel.Range("A2").Select()

'objExcel.ActiveSheet.Cells.CurrentRegion.FreezePanes(OWC.SheetFreezePanesEnum.ssFreezeTop)

 

[Alvin Bruney [MVP]]

assuming this is a client-side approach, the freeze pane call will work.
you'll just need to set the active cell before the freeze pane call. If you
don't, excel freezes on any cell that has the focus. If no cell has the
focus, it doesn't freeze.