Properties and methods that have been added to existing objects in Microsoft Excel 97 are listed in the following table (sorted by object name). For more information about the changes to the Microsoft Excel 97 object model, see one of the following topics:
New Properties and Methods (Alphabetic List)
Changes to Visual Basic in Microsoft Excel for Windows 95
| Object | New properties and methods |
|---|---|
| Application | Assistant Property, CommandBars Property, ControlCharacters Property, CursorMovement Property, DefaultSaveFormat Property, DefaultSheetDirection Property, DisplayCommentIndicator Property, EnableEvents Property, EnableSound Property, FileSearch Property, ODBCErrors Property, ODBCTimeout Property, PivotTableSelection Property, RecentFiles Property, RollZoom Property, SaveWorkspace Method, ShowChartTipNames Property, ShowChartTipValues Property, UserControl Property, VBE Property, WorksheetFunction Property |
| AutoCorrect | CorrectCapsLock Property, CorrectSentenceCap Property |
| Axis | BaseUnit Property, BaseUnitIsAuto Property, CategoryType Property, Height Property, Left Property, MajorUnitScale Property, MinorUnitScale Property, Top Property, Width Property |
| AxisTitle | AutoScaleFont Property, Fill Property, ReadingOrder Property |
| Chart | ApplyCustomType Method, BarShape Property, ChartType Property, CodeName Property, DataTable Property, Export Method, GetChartElement Method, HasDataTable Property, Hyperlinks Property, Location Method, PlotBy Property, ProtectData Property, ProtectFormatting Property, ProtectGoalSeek Property, ProtectSelection Property, Refresh Method, SetSourceData Method, Shapes Property, ShowWindow Property |
| ChartArea | AutoScaleFont Property, Fill Property |
| ChartGroup | BubbleScale Property, Has3DShading Property, Index Property, SecondPlotSize Property, ShowNegativeBubbles Property, SizeRepresents Property, SplitType Property, SplitValue Property |
| ChartObject | ProtectChartObject Property, ShapeRange Property |
| ChartObjects | ShapeRange Property |
| Charts | HPageBreaks Property, VPageBreaks Property |
| ChartTitle | AutoScaleFont Property, Fill Property, ReadingOrder Property |
| DataLabel | AutoScaleFont Property, Fill Property, Position Property, ReadingOrder Property |
| DataLabels | AutoScaleFont Property, Fill Property, Position Property, ReadingOrder Property |
| DownBars | Fill Property |
| Floor | Fill Property, Paste Method, PictureType Property |
| Interior | InvertIfNegative Property |
| Legend | AutoScaleFont Property, Clear Method, Fill Property |
| LegendEntry | AutoScaleFont Property, Height Property, Left Property, Top Property, Width Property |
| LegendKey | Fill Property, Height Property, Left Property, MarkerSize Property, PictureType Property, PictureUnit Property, Shadow Property, Top Property, Width Property |
| OLEObject | LinkedCell Property, ListFillRange Property, ProgId Property, ShapeRange Property, SourceName Property |
| OLEObjects | AutoLoad Property, ShapeRange Property, SourceName Property |
| PageSetup | PrintComments Property |
| PivotField | AutoShow Method, AutoShowCount Property, AutoShowField Property, AutoShowRange Property, AutoShowType Property, AutoSort Method, AutoSortField Property, AutoSortOrder Property, CalculatedItems Method, Delete Method, DragToColumn Property, DragToHide Property, DragToPage Property, DragToRow Property, Formula Property, IsCalculated Property, MemoryUsed Property, ServerBased Property, ShowAllItems Property |
| PivotItem | Delete Method, Formula Property, IsCalculated Property, RecordCount Property |
| PivotItems | Add Method |
| PivotTable | CacheIndex Property, CalculatedFields Method, DisplayErrorString Property, DisplayNullString Property, EnableDrilldown Property, EnableFieldDialog Property, EnableWizard Property, ErrorString Property, GetData Method, ListFormulas Method, ManualUpdate Property, MergeLabels Property, NullString Property, PageFieldOrder Property, PageFieldStyle Property, PageFieldWrapCount Property, PageRangeCells Property, PivotCache Method, PivotFormulas Property, PivotSelect Method, PivotSelection Property, PivotTableWizard Method, PreserveFormatting Property, SelectionMode Property, SubtotalHiddenPageItems Property, TableStyle Property, Tag Property, Update Method, VacatedStyle Property |
| PlotArea | Fill Property, InsideHeight Property, InsideLeft Property, InsideTop Property, InsideWidth Property |
| Point | ApplyPictToEnd Property, ApplyPictToFront Property, ApplyPictToSides Property, Fill Property, MarkerSize Property, SecondaryPlot Property, Shadow Property |
| Range | AddComment Method, ClearComments Method, Comment Property, FormatConditions Property, FormulaLabel Property, Hyperlinks Property, IndentLevel Property, InsertIndent Method, Merge Method, MergeArea Property, MergeCells Property, QueryTable Property, ReadingOrder Property, ShrinkToFit Property, UnMerge Method, Validation Property, Value2 Property |
| Series | ApplyCustomType Method, ApplyPictToEnd Property, ApplyPictToFront Property, ApplyPictToSides Property, BarShape Property, BubbleSizes Property, ChartType Property, Fill Property, Has3DEffect Property, HasLeaderLines Property, LeaderLines Property, MarkerSize Property, Shadow Property |
| SeriesCollection | NewSeries Method |
| Sheets | HPageBreaks Property, VPageBreaks Property |
| Style | BuiltIn Property, IndentLevel Property, MergeCells Property, ReadingOrder Property, ShrinkToFit Property |
| TickLabels | AutoScaleFont Property, ReadingOrder Property |
| UpBars | Fill Property |
| Walls | Fill Property, Paste Method, PictureType Property, PictureUnit Property |
| Window | EnableResize Property, View Property |
| Workbook | AcceptAllChanges Method, AcceptLabelsInFormulas Property, AddToFavorites Method, AutoUpdateFrequency Property, AutoUpdateSaveChanges Property, ChangeHistoryDuration Property, CodeName Property, CommandBars Property, ConflictResolution Property, CustomViews Property, FollowHyperlink Method, HighlightChangesOnScreen Property, HighlightChangesOptions Method, IsAddin Property, KeepChangeHistory Property, ListChangesOnNewSheet Property, MergeWorkbook Method, PersonalViewListSettings Property, PersonalViewPrintSettings Property, PivotCaches Method, ProtectSharing Method, PurgeChangeHistoryNow Method, RefreshAll Method, RejectAllChanges Method, RemoveUser Method, ResetColors Method, TemplateRemoveExtData Property, UnprotectSharing Method, UserControl Property, VBProject Property |
| Worksheet | CircleInvalid Method, ClearCircles Method, CodeName Property, Comments Property, DisplayPageBreaks Property, DisplayRightToLeft Property, EnableCalculation Property, EnableSelection Property, HPageBreaks Property, Hyperlinks Property, QueryTables Property, ResetAllPageBreaks Method, ScrollArea Property, Shapes Property, VPageBreaks Property |
| Worksheets | HPageBreaks Property, VPageBreaks Property |