Share via

Window.FreezePanes Property

  • Article
Excel Developer Reference

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

Syntax

expression.FreezePanes

expression   A variable that represents a Window object.

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.

Visual Basic for Applications 
  Workbooks("BOOK1.XLS").Worksheets("Sheet1").Activate
ActiveWindow.FreezePanes = True

See Also