open Excel from Web: freeze panes so 1st row is always displayed at top?
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.She etFreezePanesEnum.ssFreezeTop)
''objExcel.ActiveSheet.Cells(2, 2).select()
''objExcel.ActiveSheet.Cells.FreezePanes(OWC.Sheet FreezePanesEnum.ssFreezeNone)
'attempt2
''objExcel.ActiveWindow.FreezePanes = True
''objExcel.ActiveSheet.FreezePanes = True
''objExcel.ActiveSheet.Cells.FreezePanes(OWC.Sheet FreezePanesEnum.ssFreezeTop)
'objExcel.ActiveCell.FreezePanes(OWC.SheetFreezePa nesEnum.ssFreezeTop)
'attempt3
'objExcel.Range("A2").Select()
'objExcel.ActiveSheet.Cells.CurrentRegion.FreezePa nes(OWC.SheetFreezePanesEnum.ssFreezeTop)
|