このページはアーカイブされた古いページです。
エクセル資料の一覧へ


エクセル−バージョン別新機能の一覧(4/8)
←前へ 目次 次へ→


追加されたプロパティ/メソッド/イベント

オブジェクトプロパティメソッドイベント
2000
Office2000AssistantOn


Office2000CommandBarAdaptiveMenu


Office2000CommandBarButtonHyperlinkType
IsPriorityDropped

Click
Office2000CommandBarComboBoxIsPriorityDropped

Change
Office2000CommandBarControlIsPriorityDropped


Office2000CommandBarPopupIsPriorityDropped


Office2000CommandBarsAdaptiveMenus
DisplayFonts
FindControls
OnUpdate
Excel2000ApplicationAnswerWizard
AutoPercentEntry
CalculationVersion
COMAddIns
DefaultWebOptions
ExtendList
FeatureInstall
LanguageSettings
OLEDBErrors
ProductCode
ShowWindowsInTaskbar
UserLibraryPath
CalculateFull
GetPhonetic
SheetFollowHyperlink
Excel2000AxisDisplayUnit
DisplayUnitCustom
DisplayUnitLabel
HasDisplayUnitLabel


Excel2000ChartHasPivotFields
PivotLayout
Scripts


Excel2000DataLabelNumberFormatLocal


Excel2000DataLabelsNumberFormatLocal


Excel2000HyperlinkEmailSubject
ScreenTip
TextToDisplay
CreateNewDocument

Excel2000OLEObjectAltHTML


Excel2000OLEObjectsAltHTML


Excel2000Pane
ScrollIntoView

Excel2000ParameterRefreshOnChange


Excel2000PivotCacheCommandText
CommandType
LocalConnection
MaintainConnection
QueryType
Recordset
RefreshPeriod
UseLocalConnection
CreatePivotTable
ResetTimer

Excel2000PivotCaches
Add

Excel2000PivotFieldCaption
CubeField
CurrentPageName
DragToData
DrilledDown
LayoutBlankLine
LayoutForm
LayoutPageBreak
LayoutSubtotalLocation
SubtotalName
Subtotals


Excel2000PivotItemCaption
DrilledDown


Excel2000PivotTableCubeFields
GrandTotalName
PrintTitles
RepeatItemsOnEachPrintedPage
SmallGrid
Format

Excel2000PivotTables
Add

Excel2000QueryTableAdjustColumnWidth
CommandText
CommandType
MaintainConnection
PreserveColumnInfo
PreserveFormatting
QueryType
RefreshPeriod
TextFileColumnDataTypes
TextFileCommaDelimiter
TextFileConsecutiveDelimiter
TextFileDecimalSeparator
TextFileFixedColumnWidths
TextFileOtherDelimiter
TextFileParseType
TextFilePlatform
TextFilePromptOnRefresh
TextFileSemicolonDelimiter
TextFileSpaceDelimiter
TextFileStartRow
TextFileTabDelimiter
TextFileTextQualifier
TextFileThousandsSeparator
WebConsecutiveDelimitersAsOne
WebDisableDateRecognition
WebFormatting
WebPreFormattedTextToColumns
WebSelectionType
WebSingleBlockTextImport
WebTables
ResetTimer

Excel2000RangeID
Phonetics
SetPhonetic

Excel2000ShapeAlternativeText
Script


Excel2000ShapeRangeAlternativeText


Excel2000TickLabelsAlignment
Depth
NumberFormatLocal
Offset


Excel2000Window
PointsToScreenPixelsX
PointsToScreenPixelsY
RangeFromPoint
ScrollIntoView

Excel2000WorkbookCalculationVersion
EnvelopeVisible
HTMLProject
PublishObjects
VBASigned
WebOptions
ReloadAs
WebPagePreview
SheetFollowHyperlink
Excel2000WorksheetDisplayRightToLeft
Scripts

FollowHyperlink
2002
Office2002MsoEnvelope

EnvelopeHide
EnvelopeShow
Office2002Assistant
DoAlert

Office2002FileSearch
RefreshScopes

Office2002OfficeDataSourceObject
ApplyFilter
SetSortOrder

Office2002ScopeFolder
AddToSearchFolders

Office2002SignatureSet
Commit

Office2002CommandBarButtonMask
Picture


Office2002CommandBarsDisableAskAQuestionDropdown?
DisableCustomize


Office2002FileDialogAllowMultiSelect?
ButtonName
DialogType
FilterIndex
Filters
InitialFileName
InitialView
SelectedItems


Office2002FileDialogFilterExtensions


Office2002FileSearchFileTypes
SearchFolders
SearchScopes


Office2002MsoEnvelopeCommandBars?
Introduction


Office2002ODSOFilterColumn?
CompareTo
Comparison
Conjunction


Office2002OfficeDataSourceObjectColumns?
ConnectString
DataSource
Filters
RowCount
Table


Office2002ScopeFolderPath?
ScopeFolders


Office2002SearchScopeScopeFolder


Office2002SignatureAttachCertificate?
ExpireDate
IsCertificateExpired
IsCertificateRevoked
Issuer
IsValid
SignDate
Signer


Excel2002クラス モジュールのイベントで宣言されている Workbook 型のオブジェクト

PivotTableCloseConnection
PivotTableOpenConnection
Excel2002クラス モジュールのイベントで宣言されている Worksheet 型のオブジェクト

PivotTableUpdate
Excel2002クラス モジュールのイベントで宣言されている Application 型または Workbook 型のオブジェクト

SheetPivotTableUpdate
Excel2002クラス モジュールのイベントで宣言されている Application 型のオブジェクト

WorkbookPivotTableCloseConnection
WorkbookPivotTableOpenConnection
Excel2002AllowEditRange
ChangePassword

Excel2002Application
CalculateFullRebuild
CheckAbort

Excel2002ColorFormat
SetCMYK

Excel2002CubeField
AddMemberPropertyField

Excel2002CubeFields
AddSet

Excel2002Diagram
Convert

Excel2002DiagramNode
AddNode
CloneNode
MoveNode
NextNode
PrevNode
ReplaceNode
SwapNode
TransferChildren

Excel2002DiagramNodeChildren
AddNode

Excel2002IRtdServer
ConnectData
DisconnectData
Heartbeat
RefreshData
ServerStart
ServerTerminate

Excel2002IRTDUpdateEvent
Disconnect
UpdateNotify

Excel2002PivotCache
MakeConnection
SaveAsODC

Excel2002PivotField
AddPageItem

Excel2002PivotTable
AddDataField
CreateCubeFile
GetPivotData

Excel2002QueryTable
SaveAsODC

Excel2002Range
Dirty
Speak

Excel2002RTD
RefreshData
RestartServers

Excel2002Shapes
AddDiagram

Excel2002SmartTagAction
Execute

Excel2002Speech
Speak

Excel2002UserAccessList
DeleteAll

Excel2002Workbook
BreakLink
CanCheckIn
CheckIn
EndReview
RecheckSmartTags
ReplyWithChanges
SendForReview
SetPasswordEncryptionOptions

Excel2002Workbooks
CanCheckOut
CheckOut
DiscardConflict
OfflineConflict
OpenDatabase
OpenXML

Excel2002WorksheetFunction
RTD

Excel2002AddInCLSID


Excel2002AllowEditRangeUsers


Excel2002ApplicationAutoFormatAsYouTypeReplaceHyperlinks
AutomationSecurity
AutoRecover
CalculationInterruptKey
CalculationState
DecimalSeparator
DisplayFunctionToolTips
DisplayInsertOptions
DisplayPasteOptions
ErrorCheckingOptions
FileDialog
FindFormat
GenerateGetPivotData
Hinstance
Hwnd
MapPaperSize
NewWorkbook
Ready
ReplaceFormat
RTD
ShowStartupDialog
SmartTagRecognizers
Speech
SpellingOptions
ThisCell
ThousandsSeparator
UsedObjects
UseSystemSeparators
Watches


Excel2002AutoCorrectDisplayAutoCorrectOptions


Excel2002AutoRecoverTime


Excel2002CalculatedMemberIsValid
SolveOrder


Excel2002ChartMailEnvelope
Tab


Excel2002ColorFormatBlack
Cyan
Ink
Magenta
OverPrint
TintAndShade
Yellow


Excel2002CubeFieldEnableMultiplePageItems
HasMemberProperties
ShowInFieldList


Excel2002DataLabelSeparator
ShowBubbleSize
ShowCategoryName
ShowPercentage
ShowSeriesName
ShowValue


Excel2002DataLabelsSeparator
ShowBubbleSize
ShowCategoryName
ShowPercentage
ShowSeriesName
ShowValue


Excel2002DefaultWebOptionsSaveNewWebPagesAsWebArchives
TargetBrowser


Excel2002DiagramAutoFormat
AutoLayout
Reverse


Excel2002DiagramNodeChildren
Diagram
Layout
Root
TextShape


Excel2002DiagramNodeChildrenFirstChild
LastChild


Excel2002ErrorIgnore


Excel2002ErrorCheckingOptionsBackgroundChecking
EmptyCellReferences
EvaluateToError
InconsistentFormula
IndicatorColorIndex
NumberAsText
OmittedCells
TextDate
UnlockedFormulaCells


Excel2002IRTDUpdateEventHeartbeatInterval


Excel2002PageSetupCenterFooterPicture
CenterHeaderPicture
LeftFooterPicture
LeftHeaderPicture
PrintErrors
RightFooterPicture
RightHeaderPicture


Excel2002PivotCacheADOConnection
IsConnected
MissingItemsLimit
OLAP
RobustConnect
SourceConnectionFile
SourceDataFile


Excel2002PivotCellColumnItems
CustomSubtotalFunction
DataField
PivotCellType
RowItems


Excel2002PivotFieldCurrentPageList
DatabaseSort
EnableItemSelection
HiddenItemsList
IsMemberProperty
PropertyOrder
PropertyParentField
StandardFormula


Excel2002PivotFormulaStandardFormula


Excel2002PivotItemSourceNameStandard
StandardFormula


Excel2002PivotTableCalculatedMembers
DataPivotField
DisplayEmptyColumn
DisplayEmptyRow
DisplayImmediateItems
EnableDataValueEditing
EnableFieldList
MDX
PivotSelectionStandard
ShowCellBackgroundFromOLAP
ShowPageMultipleItemLabel
ViewCalculatedMembers
VisualTotals


Excel2002ProtectionAllowDeletingColumns
AllowDeletingRows
AllowEditRanges
AllowFiltering
AllowFormattingCells
AllowFormattingColumns
AllowFormattingRows
AllowInsertingColumns
AllowInsertingHyperlinks
AllowInsertingRows
AllowSorting
AllowUsingPivotTables


Excel2002PublishObjectAutoRepublish


Excel2002QueryTableEditWebPage
RobustConnect
SourceConnectionFile
SourceDataFile
TextFileTrailingMinusNumbers
WebDisableRedirections


Excel2002RangeAllowEdit
Errors
PivotCell
SmartTags


Excel2002RTDThrottleInterval


Excel2002ShapeChild
Diagram
DiagramNode
HasDiagram
HasDiagramNode
ParentGroup


Excel2002ShapeRangeChild
Diagram
DiagramNode
HasDiagram
HasDiagramNode
ParentGroup


Excel2002SmartTagDownloadURL
Properties
SmartTagActions
XML


Excel2002SmartTagOptionsDisplaySmartTags
EmbedSmartTags


Excel2002SmartTagRecognizersRecognize


Excel2002SpeechDirection
SpeakCellOnEnter


Excel2002SpellingOptionsArabicModes
DictLang
GermanPostReform
HebrewModes
IgnoreCaps
IgnoreFileNames
IgnoreMixedDigits
KoreanCombineAux
KoreanProcessCompound
KoreanUseAutoChangeList
SuggestMainOnly
UserDict


Excel2002UserAccessAllowEdit


Excel2002WebOptionsTargetBrowser


Excel2002WorkbookEnableAutoRecover
FullNameURLEncoded
Password
PasswordEncryptionAlgorithm
PasswordEncryptionFileProperties
PasswordEncryptionKeyLength
PasswordEncryptionProvider
RemovePersonalInformation
ShowPivotTableFieldList
SmartTagOptions
UpdateLinks
WritePassword


Excel2002WorksheetCustomProperties
MailEnvelope
Protection
SmartTags
Tab


2003
Office2003DocumentLibraryVersionComments
Modified
ModifiedBy
Restore

Office2003DocumentLibraryVersionsIsVersioningEnabled


Office2003PermissionDocumentAuthor
EnableTrustedBrowser
PermissionFromPolicy
RequestPermissionURL
StoreLicenses
PolicyDescription
PolicyName
ApplyPolicy
RemoveAll

Office2003SharedWorkspaceConnected
Folders
LastRefreshed
Links
Members
SourceURL
Tasks
CreateNew
Disconnect
Refresh
RemoveDocument

Office2003SharedWorkspaceFileCreatedBy
CreatedDate
ModifiedBy
ModifiedDate


Office2003SharedWorkspaceFilesItemCountExceeded


Office2003SharedWorkspaceFolderCreatedBy
CreatedDate
FolderName
ModifiedBy
ModifiedDate


Office2003SharedWorkspaceFoldersItemCountExceeded


Office2003SharedWorkspaceLinkNotes
CreatedBy
CreatedDate
ModifiedBy
ModifiedDate


Office2003SharedWorkspaceLinksItemCountExceeded


Office2003SharedWorkspaceMemberDomainName
Email


Office2003SharedWorkspaceMembersItemCountExceeded


Office2003SharedWorkspaceTaskAssignedTo
CreatedBy
CreatedDate
DueDate
ModifiedBy
ModifiedDate
Status


Office2003SharedWorkspaceTasksItemCountExceeded


Office2003SmartDocumentSolutionID
SolutionURL
PickSolution
RefreshPane

Office2003SyncErrorType
LastSyncTime
Status
WorkspaceLastChangedBy
GetUpdate
OpenVersion
PutUpdate
ResolveConflict
Unsuspend

Office2003UserPermissionExpirationDate
Permission
UserId


Excel2003ApplicationArbitraryXMLSupportAvailable
DisplayDocumentActionTaskPane

WorkbookAfterXmlExport
WorkbookAfterXmlImport
WorkbookBeforeXmlExport
WorkbookBeforeXmlImport
WorkbookSync
Excel2003AutoCorrectAutoExpandListRange


Excel2003ErrorCheckingOptionsListDataValidation


Excel2003ListColumnListDataFormat
SharePointFormula
TotalsCalculation
XPath


Excel2003ListDataFormatAllowFillIn
Choices
DecimalPlaces
DefaultValue
IsPercent
lcid
MaxCharacters
MaxNumber
MinNumber
Required


Excel2003ListObjectActive
HeaderRowRange
InsertRowRange
ListColumns
ListRows
SharePointURL
ShowAutoFilter
ShowTotals
TotalsRowRange
XmlMap
DisplayXMLSourcePane
Unlink
Unlist
UpdateChanges

Excel2003ListRowInvalidData


Excel2003QueryTableListObject
TextFileVisualLayout


Excel2003RangeListObject
XPath


Excel2003SmartTagActionActiveXControl
CheckboxState
ExpandHelp
ListSelection
PresentInPane
RadioGroupSelection
TextboxText


Excel2003WindowsSyncScrollingSideBySide
BreakSideBySide
CompareSideBySideWith
ResetPositionsSideBySide

Excel2003Windows


Excel2003WorkbookDisplayInkComments
DocumentLibraryVersions
InactiveListBorderVisible
Permission
SharedWorkspace
SmartDocument
Sync
XmlMaps
XmlNamespaces
SaveAsXMLData
SendFaxOverInternet
XmlImport
XmlImportXml
AfterXmlExport
AfterXmlImport
BeforeXmlExport
BeforeXmlImport
Sync
Excel2003WorksheetListObjects
XmlDataQuery
XmlMapQuery

Excel2003XmlDataBindingSourceUrl
ClearSettings
LoadSettings

Excel2003XmlMapAppendOnImport
DataBinding
IsExportable
PreserveColumnFilter
PreserveNumberFormatting
RootElementName
RootElementNamespace
SaveDataSourceDefinition
Schemas
ShowImportExportValidationErrors
ExportXml
ImportXml

Excel2003XmlNamespacePrefix
Uri


Excel2003XmlNamespaces
InstallManifest

Excel2003XmlSchemaNamespace


Excel2003XPathMap
Repeating
SetValue

2007
Excel2007CommandBars
ExecuteMso
GetEnabledMso
GetImageMso
GetLabelMso
GetPressedMso
GetScreentipMso
GetSupertipMso
GetVisibleMso

Excel2007SignatureCanSetup
Details
IsSignatureLine
IsSigned
Setup
SignatureLineShape
SortHint
ShowDetails
Sign

Excel2007SignatureSetCanAddSignatureLine
ShowSignaturesPane
Subset
AddNonVisibleSignature
AddSignatureLine



←前へ 目次 次へ→





エクセル資料の一覧へページ最上部へ