| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.office.developer.web.components,microsoft.public.excel.programming
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.office.developer.web.components,microsoft.public.excel.programming
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
| Excel using Mac - Freeze Panes | Excel Discussion (Misc queries) | |||
| Excel Services and Freeze Panes | Excel Discussion (Misc queries) | |||
| Freeze Panes in Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2003 - Freeze panes | Excel Discussion (Misc queries) | |||
Hybrid Mode
