| 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) |
| 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) | |||
Threaded Mode
