Partager via


XlBuiltInDialog Enumeration

Specifies which dialog box to display.

Version Information

Version Added: Excel 2007

Name

Value

Description

xlDialogActivate

103

Activate dialog box

xlDialogActiveCellFont

476

Active Cell Font dialog box

xlDialogAddChartAutoformat

390

Add Chart Autoformat dialog box

xlDialogAddinManager

321

Addin Manager dialog box

xlDialogAlignment

43

Alignment dialog box

xlDialogApplyNames

133

Apply Names dialog box

xlDialogApplyStyle

212

Apply Style dialog box

xlDialogAppMove

170

AppMove dialog box

xlDialogAppSize

171

AppSize dialog box

xlDialogArrangeAll

12

Arrange All dialog box

xlDialogAssignToObject

213

Assign To Object dialog box

xlDialogAssignToTool

293

Assign To Tool dialog box

xlDialogAttachText

80

Attach Text dialog box

xlDialogAttachToolbars

323

Attach Toolbars dialog box

xlDialogAutoCorrect

485

Auto Correct dialog box

xlDialogAxes

78

Axes dialog box

xlDialogBorder

45

Border dialog box

xlDialogCalculation

32

Calculation dialog box

xlDialogCellProtection

46

Cell Protection dialog box

xlDialogChangeLink

166

Change Link dialog box

xlDialogChartAddData

392

Chart Add Data dialog box

xlDialogChartLocation

527

Chart Location dialog box

xlDialogChartOptionsDataLabelMultiple

724

Chart Options DataLabel Multiple dialog box

xlDialogChartOptionsDataLabels

505

Chart Options DataLabels dialog box

xlDialogChartOptionsDataTable

506

Chart Options DataTable dialog box

xlDialogChartSourceData

540

Chart SourceData dialog box

xlDialogChartTrend

350

Chart Trend dialog box

xlDialogChartType

526

Chart Type dialog box

xlDialogChartWizard

288

ChartWizard dialog box

xlDialogCheckboxProperties

435

Checkbox Properties dialog box

xlDialogClear

52

Clear dialog box

xlDialogColorPalette

161

Color Palette dialog box

xlDialogColumnWidth

47

Column Width dialog box

xlDialogCombination

73

Combination dialog box

xlDialogConditionalFormatting

583

Conditional Formatting dialog box

xlDialogConsolidate

191

Consolidate dialog box

xlDialogCopyChart

147

Copy Chart dialog box

xlDialogCopyPicture

108

Copy Picture dialog box

xlDialogCreateList

796

Create List dialog box

xlDialogCreateNames

62

Create Names dialog box

xlDialogCreatePublisher

217

Create Publisher dialog box

xlDialogCustomizeToolbar

276

Customize Toolbar dialog box

xlDialogCustomViews

493

Custom Views dialog box

xlDialogDataDelete

36

Data Delete dialog box

xlDialogDataLabel

379

Data Label dialog box

xlDialogDataLabelMultiple

723

Data Label Multiple dialog box

xlDialogDataSeries

40

Data Series dialog box

xlDialogDataValidation

525

Data Validation dialog box

xlDialogDefineName

61

Define Name dialog box

xlDialogDefineStyle

229

Define Style dialog box

xlDialogDeleteFormat

111

Delete Format dialog box

xlDialogDeleteName

110

Delete Name dialog box

xlDialogDemote

203

Demote dialog box

xlDialogDisplay

27

Display dialog box

xlDialogDocumentInspector

862

Document Inspector dialog box

xlDialogEditboxProperties

438

Editbox Properties dialog box

xlDialogEditColor

223

Edit Color dialog box

xlDialogEditDelete

54

Edit Delete dialog box

xlDialogEditionOptions

251

Edition Options dialog box

xlDialogEditSeries

228

Edit Series dialog box

xlDialogErrorbarX

463

Errorbar X dialog box

xlDialogErrorbarY

464

Errorbar Y dialog box

xlDialogErrorChecking

732

Error Checking dialog box

xlDialogEvaluateFormula

709

Evaluate Formula dialog box

xlDialogExternalDataProperties

530

External Data Properties dialog box

xlDialogExtract

35

Extract dialog box

xlDialogFileDelete

6

File Delete dialog box

xlDialogFileSharing

481

File Sharing dialog box

xlDialogFillGroup

200

Fill Group dialog box

xlDialogFillWorkgroup

301

Fill Workgroup dialog box

xlDialogFilter

447

Dialog Filter dialog box

xlDialogFilterAdvanced

370

Filter Advanced dialog box

xlDialogFindFile

475

Find File dialog box

xlDialogFont

26

Font dialog box

xlDialogFontProperties

381

Font Properties dialog box

xlDialogFormatAuto

269

Format Auto dialog box

xlDialogFormatChart

465

Format Chart dialog box

xlDialogFormatCharttype

423

Format Charttype dialog box

xlDialogFormatFont

150

Format Font dialog box

xlDialogFormatLegend

88

Format Legend dialog box

xlDialogFormatMain

225

Format Main dialog box

xlDialogFormatMove

128

Format Move dialog box

xlDialogFormatNumber

42

Format Number dialog box

xlDialogFormatOverlay

226

Format Overlay dialog box

xlDialogFormatSize

129

Format Size dialog box

xlDialogFormatText

89

Format Text dialog box

xlDialogFormulaFind

64

Formula Find dialog box

xlDialogFormulaGoto

63

Formula Goto dialog box

xlDialogFormulaReplace

130

Formula Replace dialog box

xlDialogFunctionWizard

450

Function Wizard dialog box

xlDialogGallery3dArea

193

Gallery 3D Area dialog box

xlDialogGallery3dBar

272

Gallery 3D Bar dialog box

xlDialogGallery3dColumn

194

Gallery 3D Column dialog box

xlDialogGallery3dLine

195

Gallery 3D Line dialog box

xlDialogGallery3dPie

196

Gallery 3D Pie dialog box

xlDialogGallery3dSurface

273

Gallery 3D Surface dialog box

xlDialogGalleryArea

67

Gallery Area dialog box

xlDialogGalleryBar

68

Gallery Bar dialog box

xlDialogGalleryColumn

69

Gallery Column dialog box

xlDialogGalleryCustom

388

Gallery Custom dialog box

xlDialogGalleryDoughnut

344

Gallery Doughnut dialog box

xlDialogGalleryLine

70

Gallery Line dialog box

xlDialogGalleryPie

71

Gallery Pie dialog box

xlDialogGalleryRadar

249

Gallery Radar dialog box

xlDialogGalleryScatter

72

Gallery Scatter dialog box

xlDialogGoalSeek

198

Goal Seek dialog box

xlDialogGridlines

76

Gridlines dialog box

xlDialogImportTextFile

666

Import Text File dialog box

xlDialogInsert

55

Insert dialog box

xlDialogInsertHyperlink

596

Insert Hyperlink dialog box

xlDialogInsertObject

259

Insert Object dialog box

xlDialogInsertPicture

342

Insert Picture dialog box

xlDialogInsertTitle

380

Insert Title dialog box

xlDialogLabelProperties

436

Label Properties dialog box

xlDialogListboxProperties

437

Listbox Properties dialog box

xlDialogMacroOptions

382

Macro Options dialog box

xlDialogMailEditMailer

470

Mail Edit Mailer dialog box

xlDialogMailLogon

339

Mail Logon dialog box

xlDialogMailNextLetter

378

Mail Next Letter dialog box

xlDialogMainChart

85

Main Chart dialog box

xlDialogMainChartType

185

Main Chart Type dialog box

xlDialogMenuEditor

322

Menu Editor dialog box

xlDialogMove

262

Move dialog box

xlDialogMyPermission

834

My Permission dialog box

xlDialogNameManager

977

NameManager dialog box

xlDialogNew

119

New dialog box

xlDialogNewName

978

NewName dialog box

xlDialogNewWebQuery

667

New Web Query dialog box

xlDialogNote

154

Note dialog box

xlDialogObjectProperties

207

Object Properties dialog box

xlDialogObjectProtection

214

Object Protection dialog box

xlDialogOpen

1

Open dialog box

xlDialogOpenLinks

2

Open Links dialog box

xlDialogOpenMail

188

Open Mail dialog box

xlDialogOpenText

441

Open Text dialog box

xlDialogOptionsCalculation

318

Options Calculation dialog box

xlDialogOptionsChart

325

Options Chart dialog box

xlDialogOptionsEdit

319

Options Edit dialog box

xlDialogOptionsGeneral

356

Options General dialog box

xlDialogOptionsListsAdd

458

Options Lists Add dialog box

xlDialogOptionsME

647

OptionsME dialog box

xlDialogOptionsTransition

355

Options Transition dialog box

xlDialogOptionsView

320

Options View dialog box

xlDialogOutline

142

Outline dialog box

xlDialogOverlay

86

Overlay dialog box

xlDialogOverlayChartType

186

Overlay ChartType dialog box

xlDialogPageSetup

7

Page Setup dialog box

xlDialogParse

91

Parse dialog box

xlDialogPasteNames

58

Paste Names dialog box

xlDialogPasteSpecial

53

Paste Special dialog box

xlDialogPatterns

84

Patterns dialog box

xlDialogPermission

832

Permission dialog box

xlDialogPhonetic

656

Phonetic dialog box

xlDialogPivotCalculatedField

570

Pivot Calculated Field dialog box

xlDialogPivotCalculatedItem

572

Pivot Calculated Item dialog box

xlDialogPivotClientServerSet

689

Pivot Client Server Set dialog box

xlDialogPivotFieldGroup

433

Pivot Field Group dialog box

xlDialogPivotFieldProperties

313

Pivot Field Properties dialog box

xlDialogPivotFieldUngroup

434

Pivot Field Ungroup dialog box

xlDialogPivotShowPages

421

Pivot Show Pages dialog box

xlDialogPivotSolveOrder

568

Pivot Solve Order dialog box

xlDialogPivotTableOptions

567

Pivot Table Options dialog box

xlDialogPivotTableSlicerConnections

1183

Pivot Table Slicer Connections dialog box

xlDialogPivotTableWhatIfAnalysisSettings

1153

Pivot Table What If Analysis Settings dialog box

xlDialogPivotTableWizard

312

Pivot Table Wizard dialog box

xlDialogPlacement

300

Placement dialog box

xlDialogPrint

8

Print dialog box

xlDialogPrinterSetup

9

Printer Setup dialog box

xlDialogPrintPreview

222

Print Preview dialog box

xlDialogPromote

202

Promote dialog box

xlDialogProperties

474

Properties dialog box

xlDialogPropertyFields

754

Property Fields dialog box

xlDialogProtectDocument

28

Protect Document dialog box

xlDialogProtectSharing

620

Protect Sharing dialog box

xlDialogPublishAsWebPage

653

Publish As WebPage dialog box

xlDialogPushbuttonProperties

445

Pushbutton Properties dialog box

xlDialogReplaceFont

134

Replace Font dialog box

xlDialogRoutingSlip

336

This object or member has been deprecated, but it remains part of the object model for backward compatibility. You should not use it in new applications.

xlDialogRowHeight

127

Row Height dialog box

xlDialogRun

17

Run dialog box

xlDialogSaveAs

5

SaveAs dialog box

xlDialogSaveCopyAs

456

SaveCopyAs dialog box

xlDialogSaveNewObject

208

Save New Object dialog box

xlDialogSaveWorkbook

145

Save Workbook dialog box

xlDialogSaveWorkspace

285

Save Workspace dialog box

xlDialogScale

87

Scale dialog box

xlDialogScenarioAdd

307

Scenario Add dialog box

xlDialogScenarioCells

305

Scenario Cells dialog box

xlDialogScenarioEdit

308

Scenario Edit dialog box

xlDialogScenarioMerge

473

Scenario Merge dialog box

xlDialogScenarioSummary

311

Scenario Summary dialog box

xlDialogScrollbarProperties

420

Scrollbar Properties dialog box

xlDialogSearch

731

Search dialog box

xlDialogSelectSpecial

132

Select Special dialog box

xlDialogSendMail

189

Send Mail dialog box

xlDialogSeriesAxes

460

Series Axes dialog box

xlDialogSeriesOptions

557

Series Options dialog box

xlDialogSeriesOrder

466

Series Order dialog box

xlDialogSeriesShape

504

Series Shape dialog box

xlDialogSeriesX

461

Series X dialog box

xlDialogSeriesY

462

Series Y dialog box

xlDialogSetBackgroundPicture

509

Set Background Picture dialog box

xlDialogSetManager

1109

Set Manager dialog box

xlDialogSetMDXEditor

1208

Set MDX Editor dialog box

xlDialogSetPrintTitles

23

Set Print Titles dialog box

xlDialogSetTupleEditorOnColumns

1108

Set Tuple Editor On Columns dialog box

xlDialogSetTupleEditorOnRows

1107

Set Tuple Editor On Rows dialog box

xlDialogSetUpdateStatus

159

Set Update Status dialog box

xlDialogShowDetail

204

Show Detail dialog box

xlDialogShowToolbar

220

Show Toolbar dialog box

xlDialogSize

261

Size dialog box

xlDialogSlicerCreation

1182

Slicer Creation dialog box

xlDialogSlicerPivotTableConnections

1184

Slicer Pivot Table Connections dialog box

xlDialogSlicerSettings

1179

Slicer Settings dialog box

xlDialogSort

39

Sort dialog box

xlDialogSortSpecial

192

Sort Special dialog box

xlDialogSparklineInsertColumn

1134

Sparkline Insert Column dialog box

xlDialogSparklineInsertLine

1133

Sparkline Insert Line dialog box

xlDialogSparklineInsertWinLoss

1135

Sparkline Insert Win Loss dialog box

xlDialogSplit

137

Split dialog box

xlDialogStandardFont

190

Standard Font dialog box

xlDialogStandardWidth

472

Standard Width dialog box

xlDialogStyle

44

Style dialog box

xlDialogSubscribeTo

218

Subscribe To dialog box

xlDialogSubtotalCreate

398

Subtotal Create dialog box

xlDialogSummaryInfo

474

Summary Info dialog box

xlDialogTable

41

Table dialog box

xlDialogTabOrder

394

Tab Order dialog box

xlDialogTextToColumns

422

Text To Columns dialog box

xlDialogUnhide

94

Unhide dialog box

xlDialogUpdateLink

201

Update Link dialog box

xlDialogVbaInsertFile

328

VBA Insert File dialog box

xlDialogVbaMakeAddin

478

VBA Make Addin dialog box

xlDialogVbaProcedureDefinition

330

VBA Procedure Definition dialog box

xlDialogView3d

197

View 3D dialog box

xlDialogWebOptionsBrowsers

773

Web Options Browsers dialog box

xlDialogWebOptionsEncoding

686

Web Options Encoding dialog box

xlDialogWebOptionsFiles

684

Web Options Files dialog box

xlDialogWebOptionsFonts

687

Web Options Fonts dialog box

xlDialogWebOptionsGeneral

683

Web Options General dialog box

xlDialogWebOptionsPictures

685

Web Options Pictures dialog box

xlDialogWindowMove

14

Window Move dialog box

xlDialogWindowSize

13

Window Size dialog box

xlDialogWorkbookAdd

281

Workbook Add dialog box

xlDialogWorkbookCopy

283

Workbook Copy dialog box

xlDialogWorkbookInsert

354

Workbook Insert dialog box

xlDialogWorkbookMove

282

Workbook Move dialog box

xlDialogWorkbookName

386

Workbook Name dialog box

xlDialogWorkbookNew

302

Workbook New dialog box

xlDialogWorkbookOptions

284

Workbook Options dialog box

xlDialogWorkbookProtect

417

Workbook Protect dialog box

xlDialogWorkbookTabSplit

415

Workbook Tab Split dialog box

xlDialogWorkbookUnhide

384

Workbook Unhide dialog box

xlDialogWorkgroup

199

Workgroup dialog box

xlDialogWorkspace

95

Workspace dialog box

xlDialogZoom

256

Zoom dialog box