In Microsoft Excel 2000, 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).
| Property |
Objects |
| AdjustColumnWidth |
QueryTable |
| Alignment |
TickLabels |
| AlternativeText |
Shape, ShapeRange |
| AltHTML |
OLEObject, OLEObjects |
| AnswerWizard |
Application |
| AutoPercentEntry |
Application |
| CalculationVersion |
Application, Workbook |
| Caption |
PivotField, PivotItem |
| COMAddIns |
Application |
| CommandText |
PivotCache, QueryTable |
| CommandType |
PivotCache, QueryTable |
| CubeField |
PivotField |
| CubeFields |
PivotTable |
| CurrentPageName |
PivotField |
| DefaultWebOptions |
Application |
| Depth |
TickLabels |
| DisplayRightToLeft |
Worksheet |
| DisplayUnit |
Axis |
| DisplayUnitCustom |
Axis |
| DisplayUnitLabel |
Axis |
| DragToData |
PivotField |
| DrilledDown |
PivotField, PivotItem |
| EmailSubject |
Hyperlink |
| EnvelopeVisible |
Workbook |
| ExtendList |
Application |
| FeatureInstall |
Application |
| GrandTotalName |
PivotTable |
| HasDisplayUnitLabel |
Axis |
| HasPivotFields |
Chart |
| HTMLProject |
Workbook |
| ID |
Range |
| LanguageSettings |
Application |
| LayoutBlankLine |
PivotField |
| LayoutForm |
PivotField |
| LayoutPageBreak |
PivotField |
| LayoutSubtotalLocation |
PivotField |
| LocalConnection |
PivotCache |
| MaintainConnection |
PivotCache, QueryTable |
| NumberFormatLocal |
DataLabel, DataLabels, TickLabels |
| Offset |
TickLabels |
| OLEDBErrors |
Application |
| Phonetics |
Range |
| PivotLayout |
Chart |
| PreserveColumnInfo |
QueryTable |
| PreserveFormatting |
QueryTable |
| PrintTitles |
PivotTable |
| ProductCode |
Application |
| PublishObjects |
Workbook |
| QueryType |
PivotCache, QueryTable |
| Recordset |
PivotCache |
| RefreshOnChange |
Parameter |
| RefreshPeriod |
PivotCache, QueryTable |
| RepeatItemsOnEachPrintedPage |
PivotTable |
| ScreenTip |
Hyperlink |
| Script |
Shape |
| Scripts |
Chart, Worksheet |
| ShowWindowsInTaskbar |
Application |
| SmallGrid |
PivotTable |
| SubtotalName |
PivotField |
| Subtotals |
PivotField |
| TextFileColumnDataTypes |
QueryTable |
| TextFileCommaDelimiter |
QueryTable |
| TextFileConsecutiveDelimiter |
QueryTable |
| TextFileDecimalSeparator |
QueryTable |
| TextFileFixedColumnWidths |
QueryTable |
| TextFileOtherDelimiter |
QueryTable |
| TextFileParseType |
QueryTable |
| TextFilePlatform |
QueryTable |
| TextFilePromptOnRefresh |
QueryTable |
| TextFileSemicolonDelimiter |
QueryTable |
| TextFileSpaceDelimiter |
QueryTable |
| TextFileStartRow |
QueryTable |
| TextFileTabDelimiter |
QueryTable |
| TextFileTextQualifier |
QueryTable |
| TextFileThousandsSeparator |
QueryTable |
| TextToDisplay |
Hyperlink |
| UseLocalConnection |
PivotCache |
| UserLibraryPath |
Application |
| VBASigned |
Workbook |
| WebConsecutiveDelimitersAsOne |
QueryTable |
| WebDisableDateRecognition |
QueryTable |
| WebFormatting |
QueryTable |
| WebOptions |
Workbook |
| WebPreFormattedTextToColumns |
QueryTable |
| WebSelectionType |
QueryTable |
| WebSingleBlockTextImport |
QueryTable |