Add Method (DialogSheets Collection)

Applies To

DialogSheets Collection.

Description

Creates a new dialog sheet. Returns a DialogSheet object.

Syntax

object.Add(before, after, count)

object

Required. The DialogSheets object.

before

Optional. Specifies the sheet before which the new sheet is added.

after

Optional. Specifies the sheet after which the new sheet is added.

count

Optional. The number of sheets to add. If omitted, the default is one.

Remarks

If before and after are omitted, the new sheet is inserted before the active sheet.

Example

This example creates a new dialog sheet containing a default dialog frame and buttons. The new sheet is inserted before the active sheet.


ActiveWorkbook.DialogSheets.Add