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 by object name).
| Object |
Properties |
| Application |
AnswerWizard, AutoPercentEntry, CalculationVersion, COMAddIns, DefaultWebOptions, ExtendList, FeatureInstall, LanguageSettings, OLEDBErrors, ProductCode, ShowWindowsInTaskbar, UserLibraryPath |
| Axis |
DisplayUnit, DisplayUnitCustom, DisplayUnitLabel, HasDisplayUnitLabel |
| Chart |
HasPivotFields, PivotLayout, Scripts |
| DataLabel |
NumberFormatLocal |
| DataLabels |
NumberFormatLocal |
| Hyperlink |
EmailSubject, ScreenTip, TextToDisplay |
| OLEObject |
AltHTML |
| OLEObjects |
AltHTML |
| Parameter |
RefreshOnChange |
| PivotCache |
CommandText, CommandType, LocalConnection, MaintainConnection, QueryType, Recordset, RefreshPeriod, UseLocalConnection |
| PivotField |
Caption, CubeField, CurrentPageName, DragToData, DrilledDown, LayoutBlankLine, LayoutForm, LayoutPageBreak, LayoutSubtotalLocation, SubtotalName, Subtotals |
| PivotItem |
Caption, DrilledDown |
| PivotTable |
CubeFields, GrandTotalName, PrintTitles, RepeatItemsOnEachPrintedPage, SmallGrid |
| QueryTable |
AdjustColumnWidth, 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 |
| Range |
ID, Phonetics |
| Shape |
AlternativeText, Script |
| ShapeRange |
AlternativeText |
| TickLabels |
Alignment, Depth, NumberFormatLocal, Offset |
| Workbook |
CalculationVersion, EnvelopeVisible, HTMLProject, PublishObjects, VBASigned, WebOptions |
| Worksheet |
DisplayRightToLeft, Scripts |