DialogSheets Collection Object

Description

A collection of all the DialogSheet objects in the specified or active workbook. Do not confuse a dialog sheet with the Dialog object, which represents a built-in Microsoft Excel dialog box, or the DialogFrame object, which represents the boundaries of the custom dialog box on a dialog sheet.

Accessors

Use the Add method to create a new dialog sheet and add it to the workbook. The following example adds a new dialog sheet before sheet one in the active workbook.


DialogSheets.Add before:=Sheets(1)

Use the DialogSheets method with an argument to access a single member of the collection or without an argument to access the entire collection at once. The following example moves all the dialog sheets in the active workbook to the end of the workbook.


DialogSheets.Move after:=Sheets(Sheets.Count)

The Sheets collection contains all of the sheets in the workbook (chart sheets, dialog sheets, modules, and worksheets). Use the Sheets method with an argument to access a single member of the collection or without an argument to access the entire collection at once.

Properties

Application Property, Count Property, Creator Property, Parent Property, Visible Property.

Methods

Add Method (DialogSheets Collection), Copy Method, Delete Method, Item Method, Move Method, PrintOut Method, PrintPreview Method, Select Method.

See Also

Charts Collection, Modules Collection, Sheets Method, Worksheets Collection.