Microsoft Excel VBA对象模型一览

MicrosoftExcel对象模型一览对象和集合仅对象Application对象_代表整个MicrosoftExcel应用程序属性属性方法事件ActiveCellIgnoreRemoteRequestsActivateMicrosoftAppNewWorkbookActiveChartInteractiveAddChartAutoFormatSheetActivateActivePrinterInternationalAddCustomListSheetBeforeDoubleClickActiveSheetIterationCalculateSheetBeforeRightClickActiveWindowLanguageSettingsCalculateFullSheetCalculateActiveWorkbookLeftCalculateFullRebuildSheetChangeAddInsLibraryPathCentimetersToPointsSheetDeactivateAlertBeforeOverwritingMailSessionCheckAbortSheetFollowHyperlinkAltStartupPathMailSystemCheckSpellingSheetPivotTableUpdateAnswerWizardMapPaperSizeConvertFormulaSheetSelectionChangeApplicationMathCoprocessorAvailableDDEExecuteWindowActivateArbitraryXMLSupportAvailableMaxChangeDDEInitiateWindowDeactivateAskToUpdateLinksMaxIterationsDDEPokeWindowResizeAssistantMemoryFreeDDERequestWorkbookActivateAutoCorrectMouseAvailableDDETerminateWorkbookAddinInstallAutoFormatAsYouTypeReplaceHyperlinksMoveAfterReturnDeleteChartAutoFormatWorkbookAddinUninstallAutomationSecurityMoveAfterReturnDirectionDeleteCustomListWorkbookAfterXmlExportAutoPercentEntryNameDisplayXMLSourcePaneWorkbookAfterXmlImportAutoRecoverNamesDoubleClickWorkbookBeforeCloseBuildNetworkTemplatesPathEvaluateWorkbookBeforePrintCalculateBeforeSaveNewWorkbookExecuteExcel4MacroWorkbookBeforeSaveCalculationODBCErrorsFindFileWorkbookBeforeXmlExportCalculationInterruptKeyODBCTimeoutGetCustomListContentsWorkbookBeforeXmlImportCallerOLEDBErrorsGetPhoneticWorkbookOpenCanPlaySoundsOnWindowGetSaveAsFilenameWorkbookPivotTableCloseConnectionCanRecordSoundsOperatingSystemGotoWorkbookPivotTableOpenConnectionCaptionOrganizationNameHelpWorkbookSyncCellDragAndDropParentInchesToPointsCellsPathInputBoxChartsPathSeparatorIntersectColumnsPivotTableSelectionMacroOptionsCOMAddInsPreviousSelectionsMailLogoffCommandBarsProductCodeMailLogonCommandUnderlinesPromptForSummaryInfoNextLetterConstrainNumericRangeOnKeyControlCharactersReadyOnRepeatCopyObjectsWithCellsRecentFilesOnTimeCreatorRecordRelativeOnUndoCursorReferenceStyleQuitCursorMovementRegisteredFunctionsRecordMacroCustomListCountReplaceFormatRegisterXLLCutCopyModeRollZoomRepeatDataEntryModeRowsRunDDEAppReturnCodeRTDSaveWorkspaceDecimalSeparatorScreenUpdatingSendKeysDefaultFilePathSelectionSetDefaultChartDefaultSaveFormatSheetsUndoDefaultSheetDirectionSheetsInNewWorkbookUnionDefaultWebOptionsShowChartTipNamesVolatileDialogsShowChartTipValuesWaitDisplayAlertsShowStartupDialogDisplayClipboardWindowShowToolTipsDisplayCommentIndicatorShowWindowsInTaskbarDisplayDocumentActionTaskPaneSmartTagRecognizersDisplayExcel4MenusSpeechDisplayFormulaBarSpellingOptionsDisplayFullScreenStandardFontDisplayFunctionToolTipsStandardFontSizeDisplayInsertOptionsStartupPathDisplayNoteIndicatorStatusBarDisplayPasteOptionsTemplatesPathDisplayRecentFilesThisCellDisplayScrollBarsThisWorkbookDisplayStatusBarThousandsSeparatorEditDirectlyInCellTopEnableAnimationsTransitionMenuKeyEnableAutoCompleteTransitionMenuKeyActionEnableCancelKeyTransitionNavigKeysEnableEventsUsableHeightEnableSoundUsedObjectsErrorCheckingOptionsUserControlExcel4IntlMacroSheetsUserLibraryPathExcel4MacroSheetsUserNameExtendListUseSystemSeparatorsFeatureInstallValueFileConvertersVBEFileDialogVersionFileFindVisibleFileSearchWatchesFindFormatWidthFixedDecimalWindowsFixedDecimalPlacesWindowsForPensGenerateGetPivotDataWindowStateHeightWorkbooksHinstanceWorksheetFunctionHwndWorksheetsAddIns集合对象_代表Excel的所有可用加载宏属性属性方法ApplicationCreatorAddCountItemParentAddIn对象_代表已安装或尚未安装的单个加载宏属性属性方法ApplicationNameCLSIDParentFullNamePathInstalledprogIDAnswer_隐藏AutoCorrect对象_包含MicrosoftExcel的AutoCorrect属性（星期的大写名称、对第一第二个字母为大写的词的更正、自动更改清单等）属性属性方法ApplicationCorrectSentenceCapAddReplacementAutoExpandListRangeDisplayAutoCorrectOptionsDeleteReplacementAutoFillFormulasInListsParentCapitalizeNamesOfDaysReplacementListCorrectCapsLockReplaceTextTwoInitialCapitalsAssistant对象_代表“MicrosoftOffice助手”属性属性方法AnimationLeftActivateWizardApplicationMouseTipsDoAlertAssistWithAlertsMoveWhenInTheWayEndWizardAssistWithHelpNameHelpAssistWithWizardsNewBalloonMoveBalloonErrorOnResetTipsCreatorParentStartWizardFeatureTipsReducedFileNameSearchWhenProgrammingGuessHelpSoundsHighPriorityTipsTipOfDayItemTopKeyboardShortcutTipsVisibleAutoRecover对象_代表工作簿的自动恢复功能属性属性方法ApplicationParentEnabledPathTimeCellFormat对象_表示单元格格式的搜索条件属性属性方法AddIndentLockedClearApplicationMergeCellsBordersNumberFormatFontNumberFormatLocalFormulaHiddenOrientationHorizontalAlignmentParentIndentLevelShrinkToFitInteriorVerticalAlignmentWrapTextBorders集合对象_代表Range对象或Style对象的四个边框Fon对象_包含对象的字体属性Interior对象_代表对象的内部COMAddIns集合对象_COMAddIn对象的集合，这些对象提供有关在Windows注册表中注册的COM加载项的信息属性属性方法ApplicationCreatorItemCountParentUpdateCOMAddIn对象_代表MicrosoftOffice宿主应用程序中的一个COM加载项属性属性方法ApplicationGuidConnectObjectCreatorParentDescriptionProgIdDebug对象_Debug对象在运行时将输出发送到Immediate窗口属性属性方法PrintAssertDialogs集合对象_Excel中所有Dialog对象的集合属性属性方法ApplicationItemCountParentDialog对象_代表内置的MicrosoftExcel对话框属性属性方法枚举ApplicationShowXlBuiltInDialogParentCommandBars集合对象_代表容器应用程序中命令栏的CommandBar对象的集合属性属性方法事件ActionControlDisableCustomizeAddOnUpdateActiveMenuBarDisplayFontsExecuteMsoAdaptiveMenusDisplayKeysInTooltipsFindControlApplicationDisplayTooltipsFindControlsCountItemGetEnabledMsoCreatorLargeButtonsGetImageMsoDisableAskAQuestionDropdownMenuAnimationStyleGetLabelMsoParentGetPressedMsoGetScreentipMsoGetSupertipMsoGetVisibleMsoReleaseFocusCommandBar对象_代表容器应用程序中的一个命令栏属性属性方法AdaptiveMenuNameDeleteApplicationNameLocalFindControlBuiltInParentResetContextPositionShowPopupControlsProtectionCreatorRowIndexEnabledTopHeightTypeIndexVisibleLeftWidthErrorCheckingOptions对象_代表应用程序的错误检查选项属性属性方法ApplicationIndicatorColorIndexBackgroundCheckingListDataValidationEmptyCellReferencesNumberAsTextEvaluateToErrorOmittedCellsInconsistentFormulaParentInconsistentTableFormulaTextDateUnlockedFormulaCellsLanguageSettings对象_返回MicrosoftOffice应用程序中有关语言设置的信息属性属性方法ApplicationLanguageIDCreatorLanguagePreferredForEditingParentNames集合对象_应用程序或工作簿中所有Name对象的集合属性属性方法ApplicationCreatorAddCountParentItemName对象_代表单元格区域的定义名属性属性方法ApplicationParentDeleteCategoryRefersToCategoryLocalRefersToLocalCommentRefersToR1C1IndexRefersToR1C1LocalIsWorkbookParameterRefersToRangeMacroTypeShortcutKeyNameValidWorkbookParameterNameLocalValueVisibleRange集合对象_代表某一单元格、某一行、某一列、某一选定区域Name对象_代表单元格区域的定义名Windows集合对象_Excel中所有Window对象的集合属性属性方法ApplicationItemArrangeCountParentBreakSideBySideCreatorSyncScrollingSideBySideCompareSideBySideWithResetPositionsSideBySideWindow对象_代表一个窗口属性属性方法ActiveCellPanesActivateActiveChartParentActivateNextActivePaneRangeSelectionActivatePreviousActiveSheetScrollColumnCloseApplicationScrollRowLargeScrollCaptionSelectedSheetsNewWindowCreatorSelectionPointsToScreenPixelsXDisplayFormulasSplitPointsToScreenPixelsYDisplayGridlinesSplitColumnPrintOutDisplayHeadingsSplitHorizontalPrintPreviewDisplayHorizontalScrollBarSplitRowRangeFromPointDisplayOutlineSplitVerticalScrollIntoViewDisplayRightToLeftTabRatioScrollWorkbookTabsDisplayVerticalScrollBarTopSmallScrollDisplayWorkbookTabsTypeDisplayZerosUsableHeightEnableResizeUsableWidthFreezePanesViewGridlineColorVisibleGridlineColorIndexVisibleRangeHeightWidthIndexWindowNumberLeftWindowStateOnWindowZoomChart对象_代表工作簿中的图表Panes集合对象_指定的窗口中所有Pane对象的集合Pane对象_代表窗口中的窗格Range集合对象_代表某一单元格、某一行、某一列、某一选定区域Sheets集合对象_指定的或活动工作簿中所有工作表的集合,Sheets集合可包含Chart对象或Worksheet对象WorksheetFunction对象_用作可从VB中调用的Excel工作表函数的容器属性方法方法方法ApplicationAccrIntFInvOddFYieldParentAccrIntMFisherOddLPriceAcosFisherInvOddLYieldAcoshFixedOrAmorDegrcFloorPearsonAmorLincForecastPercentileAndFrequencyPercentRankAscFTestPermutAsinFvPhoneticAsinhFVSchedulePiAtan2GammaDistPmtAtanhGammaInvPoissonAveDevGammaLnPowerAverageGcdPpmtAverageIfGeoMeanPriceAverageIfsGeStepPriceDiscBahtTextGrowthPriceMatBesselIHarMeanProbBesselJHex2BinProductBesselKHex2DecProperBesselYHex2OctPvBetaDistHLookupQuartileBetaInvHypGeomDistQuotientBin2DecIfErrorRadiansBin2HexImAbsRandBetweenBin2OctImaginaryRankBinomDistImArgumentRateCeilingImConjugateReceivedChiDistImCosReplaceChiInvImDivReplaceBChiTestImExpReptChooseImLnRomanCleanImLog10RoundCombinImLog2RoundDownComplexImPowerRoundUpConfidenceImProductRSqConvertImRealRTDCorrelImSinSearchCoshImSqrtSearchBCountImSubSeriesSumCountAImSumSinhCountBlankIndexSkewCountIfInterceptSlnCountIfsIntRateSlopeCoupDayBsIpmtSmallCoupDaysIrrSqrtPiCoupDaysNcIsErrStandardizeCoupNcdIsErrorStDevCoupNumIsEvenStDevPCoupPcdIsLogicalStEyxCovarIsNASubstituteCritBinomIsNonTextSubtotalCumIPmtIsNumberSumCumPrincIsOddSumIfDAverageIspmtSumIfsDays360IsTextSumProductDbKurtSumSqDbcsLargeSumX2MY2DCountLcmSumX2PY2DCountALinEstSumXMY2DdbLnSydDec2BinLogTanhDec2HexLog10TBillEqDec2OctLogEstTBillPriceDegreesLogInvTBillYieldDeltaLogNormDistTDistDevSqLookupTextDGetMatchTInvDiscMaxTransposeDMaxMDetermTrendDMinMDurationTrimDollarMedianTrimMeanDollarDeMinTTestDollarFrMInverseUSDollarDProductMIrrVarDStDevMMultVarPDStDevPModeVdbDSumMRoundVLookupDurationMultiNomialWeekdayDVarNegBinomDistWeekNumDVarPNetworkDaysWeibullEDateNominalWorkDayEffectNormDistXirrEoMonthNormInvXnpvErfNormSDistYearFracErfCNormSInvYieldDiscEvenNPerYieldMatExponDistNpvZTestFactOct2BinFactDoubleOct2DecFDistOct2HexFindOddFindBOddFPriceRecentFiles集合对象_代表最近使用文件的列表属性属性方法ApplicationItemAddCountMaximumParentRecentFile对象_代表最近使用的文件列表中的某个文件属性属性方法ApplicationNameDeleteIndexParentOpenPathSmartTagRecognizers集合对象_代表在进行操作时，用信息类型标记数据的识别引擎属性属性方法ApplicationItemCountParentRecognizeSmartTagRecognizer对象_代表在MicrosoftExcel中进行操作时，用信息类型标记数据的识别引擎属性属性方法ApplicationFullNameEnabledParentprogIDSpeech对象_包括与语音相关的方法和属性属性属性方法DirectionSpeakSpeakCellOnEnterSpellingOptions对象_代表工作表的各种拼写检查选项属性属性方法ArabicModesIgnoreMixedDigitsDictLangKoreanCombineAuxGermanPostReformKoreanProcessCompoundHebrewModesKoreanUseAutoChangeListIgnoreCapsSuggestMainOnlyIgnoreFileNamesUserDictFileSearch对象_已隐藏属性FileSearchVBE对象_该对象代表VisualBasic编辑器ODBCErrors集合对象_每一个ODBCError对象都代表一个由最近的ODBC查询返回的错误属性属性方法ApplicationItemCountParentODBCError对象_代表一个由最近的ODBC查询生成的ODBC错误属性属性方法ApplicationParentErrorStringSqlStateOLEDBErrors集合对象_每一个OLEDBError对象都代表最近的OLEDB查询返回的一个错误属性属性方法ApplicationItemCountParentOLEDBError对象_代表由上一次OLEDB查询所返回的OLEDB错误属性属性方法ApplicationNumberErrorStringParentNativeSqlStateStageDefaultWebOptions对象_包含应用程序级的全局属性，当将文档另存为网页或打开网页时，MicrosoftExcel将使用这些属性属性属性方法AllowPNGOrganizeInFolderAlwaysSaveInDefaultEncodingParentApplicationPixelsPerInchCheckIfOfficeIsHTMLEditorRelyOnCSSDownloadComponentsRelyOnVMLEncodingSaveHiddenDataFolderSuffixSaveNewWebPagesAsWebArchivesFontsScreenSizeLoadPicturesTargetBrowserLocationOfComponentsUpdateLinksOnSaveUseLongFileNamesUsedObjects集合对象_代表工作簿中已分配的对象属性属性方法ApplicationItemCountParentWatches集合对象_指定应用程序中所有Watch对象的集合属性属性方法ApplicationItemAddCountParentDeleteWatch对象_代表在重新计算工作表时跟踪的区域属性属性方法ApplicationDeleteParentSourceWorkbooks集合对象_应用程序中当前打开的所有Workbook对象的集合属性属性方法ApplicationCreatorAddCountItemCanCheckOutParentCheckOutCloseOpenOpenDatabaseOpenTextOpenXMLWorkbook对象_代表MicrosoftExcel工作簿属性属性方法事件AcceptLabelsInFormulasParentAcceptAllChangesActivateActiveChartPasswordActivateAddinInstallActiveSheetPasswordEncryptionAlgorithmAddToFavoritesAddinUninstallApplicationPasswordEncryptionFilePropertiesBreakLinkAfterXmlExportAutoUpdateFrequencyPasswordEncryptionKeyLengthCanCheckInAfterXmlImportAutoUpdateSaveChangesPasswordEncryptionProviderChangeFileAccessBeforeCloseBuiltinDocumentPropertiesPathChangeLinkBeforePrintCalculationVersionPermissionCheckInBeforeSaveChangeHistoryDurationPersonalViewListSettingsCloseBeforeXmlExportChartsPersonalViewPrintSettingsDeleteNumberFormatBeforeXmlImportCodeNamePrecisionAsDisplayedEndReviewDeactivateColorsProtectStructureExclusiveAccessNewSheetCommandBarsProtectWindowsFollowHyperlinkOpenConflictResolutionPublishObjectsForwardMailerPivotTableCloseConnectionContainerReadOnlyHighlightChangesOptionsPivotTableOpenConnectionCreateBackupReadOnlyRecommendedLinkInfoSheetActivateCreatorRemovePersonalInformationLinkSourcesSheetBeforeDoubleClickCustomDocumentPropertiesRevisionNumberMergeWorkbookSheetBeforeRightClickCustomViewsRoutedNewWindowSheetCalculateDate1904RoutingSlipOpenLinksSheetChangeDisplayDrawingObjectsSavedPivotCachesSheetDeactivateDisplayInkCommentsSaveLinkValuesPostSheetFollowHyperlinkDocumentLibraryVersionsSharedWorkspacePrintOutSheetPivotTableUpdateEnableAutoRecoverSheetsPrintPreviewSheetSelectionChangeEnvelopeVisibleShowConflictHistoryProtectSyncExcel4IntlMacroSheetsShowPivotTableFieldListProtectSharingWindowActivateExcel4MacroSheetsSmartDocumentPurgeChangeHistoryNowWindowDeactivateFileFormatSmartTagOptionsRecheckSmartTagsWindowResizeFullNameStylesRefreshAllFullNameURLEncodedSyncRejectAllChangesHasPasswordTemplateRemoveExtDataReloadAsHasRoutingSlipUpdateLinksRemoveUserHighlightChangesOnScreenUpdateRemoteReferencesReplyHTMLProjectUserStatusReplyAllInactiveListBorderVisibleVBASignedReplyWithChangesIsAddinVBProjectResetColorsIsInPlaceWebOptionsRouteKeepChangeHistoryWindowsRunAutoMacrosListChangesOnNewSheetWorksheetsSaveMailerWritePasswordSaveAsMultiUserEditingWriteReservedSaveAsXMLDataNameWriteReservedBySaveCopyAsNamesXmlMapsSendFaxOverInternetXmlNamespacesSendForReviewSendMailSendMailerSetLinkOnDataSetPasswordEncryptionOptionsUnprotectUnprotectSharingUpdateFromFileUpdateLinkWebPagePreviewXmlImportXmlImportXmlWorksheets集合对象_指定的或活动工作簿中所有Worksheet对象的集合属性属性方法ApplicationItemAddCountParentCopyHPageBreaksVisibleDeleteVPageBreaksFillAcrossSheetsMovePrintOutPrintPreviewSelectWorksheet对象_代表一张工作表属性属性方法事件ApplicationNamesActivateActivateAutoFilterNextCalculateBeforeDoubleClickAutoFilterModeOutlineChartObjectsBeforeRightClickCellsPageSetupCheckSpellingCalculateCircularReferenceParentCircleInvalidChangeCodeNamePreviousClearArrowsDeactivateColumnsProtectContentsClearCirclesFollowHyperlinkCommentsProtectDrawingObjectsCopyPivotTableUpdateConsolidationFunctionProtectionDeleteSelectionChangeConsolidationOptionsProtectionModeEvaluateConsolidationSourcesProtectScenariosMoveCreatorQueryTablesOLEObjectsCustomPropertiesRangePasteDisplayPageBreaksRowsPasteSpecialDisplayRightToLeftScriptsPivotTablesEnableAutoFilterScrollAreaPivotTableWizardEnableCalculationShapesPrintOutEnableOutliningSmartTagsPrintPreviewEnablePivotTableStandardHeightProtectEnableSelectionStandardWidthResetAllPageBreaksFilterModeTabSaveAsHPageBreaksTransitionExpEvalScenariosHyperlinksTypeSelectIndexUsedRangeSetBackgroundPictureListObjectsVisibleShowAllDataMailEnvelopeVPageBreaksShowDataFormNameUnprotectXmlDataQueryXmlMapQueryNames集合对象_应用程序或工作簿中所有Name对象的集合Range集合对象_代表某一单元格、某一行、某一列、某一选定区域属性属性方法方法AddIndentLocationInTableActivateFillUpAddressLockedAddCommentFindAddressLocalMergeAreaAdvancedFilterFindNextAllowEditMergeCellsApplyNamesFindPreviousApplicationNameApplyOutlineStylesFunctionWizardAreasNextAutoCompleteGoalSeekBordersNumberFormatAutoFillGroupCellsNumberFormatLocalAutoFilterInsertCharactersOffsetAutoFitInsertIndentColumnOrientationAutoFormatJustifyColumnsOutlineLevelAutoOutlineMergeColumnWidthPageBreakBorderAroundNavigateArrowCommentParentCalculateNoteTextCountPhoneticCheckSpellingParseCreatorPhoneticsClearPasteSpecialCurrentArrayPivotCellClearCommentsPrintOutCurrentRegionPivotFieldClearContentsPrintPreviewDependentsPivotItemClearFormatsRemoveSubtotalDirectDependentsPivotTableClearNotesReplaceDirectPrecedentsPrecedentsClearOutlineRowDifferencesEndPrefixCharacterColumnDifferencesRunEntireColumnPreviousConsolidateSelectEntireRowQueryTableCopySetPhoneticErrorsRangeCopyFromRecordsetShowFontReadingOrderCopyPictureShowDependentsFormatConditionsResizeCreateNamesShowErrorsFormulaRowCreatePublisherShowPrecedentsFormulaArrayRowHeightCutSortFormulaHiddenRowsDataSeriesSortSpecialFormulaLabelShowDetailDeleteSpeakFormulaLocalShrinkToFitDialogBoxSpecialCellsFormulaR1C1SmartTagsDirtySubscribeToFormulaR1C1LocalSoundNoteEditionOptionsSubtotalHasArrayStyleFillDownTableHasFormulaSummaryFillLeftTextToColumnsHeightTextFillRightUngroupHiddenTopUnMergeHorizontalAlignmentUseStandardHeightHyperlinksUseStandardWidthIDValidationIndentLevelValueInteriorValue2ItemVerticalAlignmentLeftWidthListHeaderRowsWorksheetListObjectWrapTextXpathAreas集合对象_代表选定区域内的子区域或连续单元格块的集合属性属性方法ApplicationCreatorCountItemParentRange集合对象_代表某一单元格、某一行、某一列、某一选定区域Borders集合对象_代表Range对象或Style对象的四个边框属性属性方法ApplicationItemColorLineStyleColorIndexParentCountValueCreatorWeightBorder对象_代表对象的边框属性属性方法ApplicationParentColorThemeColorColorIndexTintAndShadeLineStyleWeightErrors集合对象_表示某个区域的各种电子表格错误属性属性方法ApplicationItemCreatorParentError对象_代表区域的电子表格错误属性属性方法ApplicationParentIgnoreValueFont对象_包含对象的字体属性属性属性方法ApplicationNameBackgroundOutlineFontBoldParentColorShadowColorIndexSizeCreatorStrikethroughFontStyleSubscriptItalicSuperscriptUnderlineInterior对象_代表对象的内部属性属性方法ApplicationParentColorPatternColorIndexPatternColorCreatorPatternColorIndexInvertIfNegativeCharacters对象_代表包含文本的对象中的字符属性属性方法ApplicationParentDeleteCaptionPhoneticCharactersInsertCountTextCreatorFontFont对象_包含对象的字体属性Name对象_代表单元格区域的定义名Style对象_代表区域的样式说明属性属性方法AddIndentInteriorDeleteApplicationLockedBordersMergeCellsBuiltInNameFontNameLocalFormulaHiddenNumberFormatHorizontalAlignmentNumberFormatLocalIncludeAlignmentOrientationIncludeBorderParentIncludeFontReadingOrderIncludeNumberShrinkToFitIncludePatternsValueIncludeProtectionVerticalAlignmentIndentLevelWrapTextBorders集合对象_代表Range对象或Style对象的四个边框Font对象_包含对象的字体属性Interior对象_代表对象的内部FormatConditions集合对象_代表一个区域内所有条件格式的集合属性属性方法ApplicationCreatorAddCountParentDeleteItemFormatCondition对象_代表条件格式属性属性方法ApplicationOperatorDeleteAppliesToParentModifyBordersPriorityModifyAppliesToRangeFontPTConditionSetFirstPriorityFormatRowScopeTypeSetLastPriorityFormula1StopIfTrueFormula2TextInteriorTextOperatorNumberFormatTypeHyperlinks集合对象_代表工作表或区域的超链接的集合属性属性方法ApplicationCreatorAddCountItemDeleteParentHyperlink对象_代表一个超链接属性属性方法AddressRangeAddToFavoritesApplicationScreenTipCreateNewDocumentEmailSubjectShapeDeleteNameSubAddressFollowParentTextToDisplayTypeValidation对象_代表工作表区域的数据有效性规则属性属性方法ApplicationInputMessageAddErrorMessageInputTitleDeleteErrorTitleOperatorModifyFormula1ParentAlertStyleFormula2ShowErrorIgnoreBlankShowInputIMEModeTypeInCellDropdownValueComments集合对象_单元格批注的集合Phonetics集合对象_指定的区域中所有Phonetic对象的集合属性属性方法AlignmentItemAddApplicationLengthDeleteCharacterTypeParentCountStartFontTextVisiblePhonetic对象_包含单元格中特定拼音文本串的有关信息属性属性方法AlignmentFontApplicationParentCharacterTypeTextVisibleShapes集合对象_指定的工作表上的所有Shape对象的集合属性属性方法ApplicationAddCalloutCountAddChartParentAddConnectorRangeAddCurveAddFormControlAddLabelAddLineAddOLEObjectAddPictureAddPolylineAddShapeAddTextboxAddTextEffectBuildFreeformItemSelectAllShape对象_代表绘图层中的对象，例如自选图形、任意多边形、OLE对象或图片属性属性方法AdjustmentsLockedApplyAlternativeTextNameCopyApplicationNodesCopyPictureAutoShapeTypeOLEFormatCutBackgroundStyleOnActionDeleteBlackWhiteModeParentDuplicateBottomRightCellParentGroupFlipCalloutPictureFormatIncrementLeftChartPlacementIncrementRotationChildReflectionIncrementTopConnectionSiteCountRotationPickUpConnectorScriptRerouteConnectionsConnectorFormatShadowScaleHeightControlFormatShapeStyleScaleWidthFillSoftEdgeSelectFormControlTypeTextEffectSetShapesDefaultPropertiesGlowTextFrameUngroupGroupItemsTextFrame2ZOrderHasChartThreeDHeightTopHorizontalFlipTopLeftCellHyperlinkTypeIDVerticalFlipLeftVerticesLineVisibleLinkFormatWidthLockAspectRatioZOrderPositionLinkFormat对象_包含链接OLE对象的属性属性属性方法ApplicationLockedUpdateAutoUpdateParentOLEFormat对象_包含OLE对象的属性属性属性方法ApplicationParentActivateObjectprogIDVerbHyperlink对象_代表一个超链接属性属性方法AddressRangeAddToFavoritesApplicationScreenTipCreateNewDocumentEmailSubjectShapeDeleteNameSubAddressFollowParentTextToDisplayTypeFillformat对象_代表形状的填充格式属性属性方法ApplicationPresetTextureOneColorGradientBackColorRotateWithObjectPatternedCreatorTextureAlignmentPresetGradientForeColorTextureHorizontalScalePresetTexturedGradientColorTypeTextureNameSolidGradientDegreeTextureOffsetXTwoColorGradientGradientStopsTextureOffsetYUserPictureGradientStyleTextureTileUserTexturedGradientVariantTextureTypeParentTextureVerticalScalePatternTransparencyPresetGradientTypeTypeVisibleControlFormat对象_包含MicrosoftExcel控件属性属性属性方法ApplicationLockedTextAddItemDropDownLinesMaxListEnabledMinRemoveAllItemsLargeChangeMultiSelectRemoveItemLinkedCellParentListCountPrintObjectListFillRangeSmallChangeListIndexV