New Properties (by Object)

Microsoft Excel Visual Basic

New Properties (by Object)

   

In Microsoft Excel 2002, many new Visual Basic for Applications properties have been added to existing objects. These properties are listed in the following table (sorted by object name).

ObjectsProperties
AddIn CLSID
AllowEditRange
Users
Application
AutoFormatAsYouTypeReplaceHyperlinks
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
AutoCorrect
DisplayAutoCorrectOptions
AutoRecover
Time
CalculatedMember
IsValid
SolveOrder
Chart
MailEnvelope
Tab
ColorFormat
Black
Cyan
Ink
Magenta
OverPrint
TintAndShade
Yellow
CubeField
EnableMultiplePageItems
HasMemberProperties
ShowInFieldList
DataLabel
Separator
ShowBubbleSize
ShowCategoryName
ShowPercentage
ShowSeriesName
ShowValue
DataLabels
Separator
ShowBubbleSize
ShowCategoryName
ShowPercentage
ShowSeriesName
ShowValue
DefaultWebOptions
SaveNewWebPagesAsWebArchives
TargetBrowser
Diagram
AutoFormat
AutoLayout
Reverse
DiagramNode
Children
Diagram
Layout
Root
TextShape
DiagramNodeChildren
FirstChild
LastChild
Error
Ignore
ErrorCheckingOptions
BackgroundChecking
EmptyCellReferences
EvaluateToError
InconsistentFormula
IndicatorColorIndex
NumberAsText
OmittedCells
TextDate
UnlockedFormulaCells
IRTDUpdateEvent
HeartbeatInterval
PageSetup
CenterFooterPicture
CenterHeaderPicture
LeftFooterPicture
LeftHeaderPicture
PrintErrors
RightFooterPicture
RightHeaderPicture
PivotCache
ADOConnection
IsConnected
MissingItemsLimit
OLAP
RobustConnect
SourceConnectionFile
SourceDataFile
PivotCell
ColumnItems
CustomSubtotalFunction
DataField
PivotCellType
RowItems
PivotField
CurrentPageList
DatabaseSort
EnableItemSelection
HiddenItemsList
IsMemberProperty
PropertyOrder
PropertyParentField
StandardFormula
PivotFormula
StandardFormula
PivotItem
SourceNameStandard
StandardFormula
PivotTable
CalculatedMembers
DataPivotField
DisplayEmptyColumn
DisplayEmptyRow
DisplayImmediateItems
EnableDataValueEditing
EnableFieldList
MDX
PivotSelectionStandard
ShowCellBackgroundFromOLAP
ShowPageMultipleItemLabel
ViewCalculatedMembers
VisualTotals
Protection
AllowDeletingColumns
AllowDeletingRows
AllowEditRanges
AllowFiltering
AllowFormattingCells
AllowFormattingColumns
AllowFormattingRows
AllowInsertingColumns
AllowInsertingHyperlinks
AllowInsertingRows
AllowSorting
AllowUsingPivotTables
PublishObject
AutoRepublish
QueryTable
EditWebPage
RobustConnect
SourceConnectionFile
SourceDataFile
TextFileTrailingMinusNumbers
WebDisableRedirections
Range
AllowEdit
Errors
PivotCell
SmartTags
RTD
ThrottleInterval
Shape
Child
Diagram
DiagramNode
HasDiagram
HasDiagramNode
ParentGroup
ShapeRange
Child
Diagram
DiagramNode
HasDiagram
HasDiagramNode
ParentGroup
SmartTag
DownloadURL
Properties
SmartTagActions
XML
SmartTagOptions
DisplaySmartTags
EmbedSmartTags
SmartTagRecognizers
Recognize
Speech
Direction
SpeakCellOnEnter
SpellingOptions
ArabicModes
DictLang
GermanPostReform
HebrewModes
IgnoreCaps
IgnoreFileNames
IgnoreMixedDigits
KoreanCombineAux
KoreanProcessCompound
KoreanUseAutoChangeList
SuggestMainOnly
UserDict
UserAccess
AllowEdit
WebOptions
TargetBrowser
Workbook
EnableAutoRecover
FullNameURLEncoded
Password
PasswordEncryptionAlgorithm
PasswordEncryptionFileProperties
PasswordEncryptionKeyLength
PasswordEncryptionProvider
RemovePersonalInformation
ShowPivotTableFieldList
SmartTagOptions
UpdateLinks
WritePassword
Worksheet
CustomProperties
MailEnvelope
Protection
SmartTags
Tab