Borislav,
looks like this is what i'm looking for, thanks
Slán
~M


>>hi all,
>>I have a program that interacts with excel just fine but now i have to modify it and one requirement is to have a freeze pane at a particular point in there sheets (its at a different point in each sheet). is it possible to do something like OleApp.Rows.freeze?
>>Slán
>>~M
>
>
>Suppose oExcel is Excel Object in Your application, try this:
>
>

>***Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
>
>
>With oExcel.ActiveWindow
>    .SplitColumn = 5  && Column # where you want to split and freeze pane
>    .SplitRow    = 5  && Row # where you want to split and freeze pane
>    .FreezePanes = .t.
>EndWith
>
>
>*** To Unfreeze
>
>With oExcel.ActiveWindow
>    .FreezePanes = .f.
>    .SplitColumn = 0
>    .SplitRow    = 0
>EndWith
>