View Single Post
  #2   Report Post  
Posted to microsoft.public.office.developer.web.components,microsoft.public.excel.programming
Alvin Bruney [MVP] Alvin Bruney [MVP] is offline
external usenet poster
 
Posts: 1
Default open Excel from Web: freeze panes so 1st row is always displayed at top?

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
"Mad Scientist Jr" wrote in message
oups.com...
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)