FreezePanes Element (Microsoft Excel)

Specifies whether the panes of a worksheet window are frozen.

Contained In

WorksheetOptions

Remarks

The panes can be frozen or split depending on whether the <FreezePanes/> or <FrozenNoSplit/> element is specified.

If <FreezePanes/> is And <FrozenNoSplit/> is Then
specified not specified the panes are frozen, but may be split if the SplitHorizontal or SplitVertical element is specified.
not specified specified the panes are frozen but not split.
not specified not specified the panes are not frozen, but may be split if the SplitHorizontal or SplitVertical element is specified.

You cannot specify both elements for a single worksheet at the same time.

Example

See the example in the ExcelWorkbook element topic.