FrozenNoSplit Element (Microsoft Excel)

Specifies whether the frozen panes of a worksheet window are not split.

Contained In

WorksheetOptions

Remarks

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

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