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

Alvin Bruney [MVP]

2006-12-04 02:13:18 UTC

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.
--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
OWC Black book on Amazon and
www.lulu.com/owc
Look out for Excel Services for .NET coming soon

Post by 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)