>>>INKEY() is just for my test, so I can switch between VFP and Excel to watch what happens) you must remove it in production. FreezePanes freezes all rows above selected and all columns in left of selection (selection is not included).
>>
>>Does it prevent it from modifying? I probably used the wrong word. I need the column headers to be exactly the same. In other words, they should not be able to change them. How can I accomplish that?
>
>O I see, you want to Lock the Cells, not to be showed if the user scrolls down.
>To protect first row:
>
>LOCAL oExcel AS Excel.Application
>oExcel = CREATEOBJECT([Excel.Application])
>oExcel.Workbooks.Add()
>oExcel.Cells.Select
>oExcel.Selection.Locked = .f.
>oExcel.Rows("1:1").Select
>oExcel.Selection.Locked = .t.
>oExcel.ActiveWorkbook.ActiveSheet.Protect(,.t.,,.t.)
>
>oExcel.Visible = .t.
>INKEY(0)
>
When you save file with Excel using
loExcel.ActiveWorkbook.saveas(m.tcDbfFile, 11)
is where a way to automatically assign code page?
Thanks.
If it's not broken, fix it until it is.
My Blog