FreezePanes Property

Applies To

Window object.

Description

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