FreezePanes Property

Microsoft Excel Visual Basic

True if split panes are frozen. Read/write Boolean.

Remarks

It’s possible for FreezePanes to be True and Split to be False, or vice versa.

This property applies only to worksheets and macro sheets.

Example

This example freezes split panes in the active window in Book1.xls.

Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
ActiveWindow.FreezePanes = True