New Properties (Alphabetic List)

Microsoft Excel Visual Basic

New Properties (Alphabetic List)

   

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 alphabetically by property name).

Properties
ADOConnection
AllowDeletingColumns
AllowDeletingRows
AllowEdit
AllowEditRanges
AllowFiltering
AllowFormattingCells
AllowFormattingColumns
AllowFormattingRows
AllowInsertingColumns
AllowInsertingHyperlinks
AllowInsertingRows
AllowSorting
AllowUsingPivotTables
ArabicModes
AutoFormat
AutoFormatAsYouTypeReplaceHyperlinks
AutoLayout
AutomationSecurity
AutoRecover
AutoRepublish
BackgroundChecking
Black
CalculatedMembers
CalculationInterruptKey
CalculationState
CenterFooterPicture
CenterHeaderPicture
Child
Children
CLSID
ColumnItems
CurrentPageList
CustomProperties
CustomSubtotalFunction
Cyan
DatabaseSort
DataField
DataPivotField
DecimalSeparator
Diagram
DiagramNode
DictLang
Direction
DisplayAutoCorrectOptions
DisplayEmptyColumn
DisplayEmptyRow
DisplayFunctionToolTips
DisplayImmediateItems
DisplayInsertOptions
DisplayPasteOptions
DisplaySmartTags
DownloadURL
EditWebPage
EmbedSmartTags
EmptyCellReferences
EnableAutoRecover
EnableDataValueEditing
EnableFieldList
EnableItemSelection
EnableMultiplePageItems
ErrorCheckingOptions
Errors
EvaluateToError
FileDialog
FindFormat
FirstChild
FullNameURLEncoded
GenerateGetPivotData
GermanPostReform
HasDiagram
HasDiagramNode
HasMemberProperties
HeartbeatInterval
HebrewModes
HiddenItemsList
Hinstance
Hwnd
Ignore
IgnoreCaps
IgnoreFileNames
IgnoreMixedDigits
InconsistentFormula
IndicatorColorIndex
Ink
IsConnected
IsMemberProperty
IsValid
KoreanCombineAux
KoreanProcessCompound
KoreanUseAutoChangeList
LastChild
Layout
LeftFooterPicture
LeftHeaderPicture
Magenta
MailEnvelope
MapPaperSize
MDX
MissingItemsLimit
NewWorkbook
NumberAsText
OLAP
OmittedCells
OverPrint
ParentGroup
Password
PasswordEncryptionAlgorithm
PasswordEncryptionFileProperties
PasswordEncryptionKeyLength
PasswordEncryptionProvider
PivotCell
PivotCellType
PivotSelectionStandard
PrintErrors
Properties
PropertyOrder
PropertyParentField
Protection
Ready
Recognize
RemovePersonalInformation
ReplaceFormat
Reverse
RightFooterPicture
RightHeaderPicture
RobustConnect
Root
RowItems
RTD
SaveNewWebPagesAsWebArchives
Separator
ShowBubbleSize
ShowCategoryName
ShowCellBackgroundFromOLAP
ShowInFieldList
ShowPageMultipleItemLabel
ShowPercentage
ShowPivotTableFieldList
ShowSeriesName
ShowStartupDialog
ShowValue
SmartTagActions
SmartTagOptions
SmartTagRecognizers
SmartTags
SolveOrder
SourceConnectionFile
SourceDataFile
SourceNameStandard
SpeakCellOnEnter
Speech
SpellingOptions
StandardFormula
SuggestMainOnly
Tab
TargetBrowser
TextDate
TextFileTrailingMinusNumbers
TextShape
ThisCell
ThousandsSeparator
ThrottleInterval
Time
TintAndShade
UnlockedFormulaCells
UpdateLinks
UsedObjects
UserDict
Users
UseSystemSeparators
ViewCalculatedMembers
VisualTotals
Watches
WebDisableRedirections
WritePassword
XML
Yellow