View Single Post
  #1   Report Post  
Posted to microsoft.public.office.developer.web.components,microsoft.public.excel.programming
Mad Scientist Jr Mad Scientist Jr is offline
external usenet poster
 
Posts: 16
Default 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)