FreezePanes Property Example
This example freezes split panes in the active window in Book1.xls.
Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate ActiveWindow.FreezePanes = True