Hi,
I'm trying to freeze the top row in each worksheet in my workbook.
I'm not quite clear on the use of "Window" in MS-Excel....every other command seems to work on a worksheet or workbook as a whole.
I have tried setting the value to freeze the top row in a worksheet, etc. but the following is the only thing that i have gotten to work when m.tiSheet = 1; the workbook has 10 sheets in it.
WITH m.toWorkbook.WINDOWS[m.tiSheet]
.SplitColumn = 0
.SplitRow = 1
.FreezePanes = .T.
ENDWITH
Can anyone help w/the correct syntax to freeze the top row in EVERY worksheet in the workbook?
TIA, appreciate it!
J