Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Object Model Changes Since Microsoft Office 97

Office 2007

The following is a summary of the changes in the Microsoft Office Excel 2007 object model as compared to Microsoft Office 97.

Application

Properties Status
CommandBars Changed

ControlCharacters Changed

FileFind Hidden
FileSearch Hidden
MemoryFree Hidden
MemoryTotal Hidden
MemoryUsed Hidden
UILanguage Hidden
VBE Changed

Methods Status
AddChartAutoFormat Hidden
DeleteChartAutoFormat Hidden
FindFile Changed

SetDefaultChart Hidden
Wait Changed

AutoCorrect

Methods Status
AddReplacement Changed

DeleteReplacement Changed

ReplacementList Removed

Axis

Methods Status
Delete Changed

Select Changed

AxisTitle

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden
Methods Status
Delete Changed

Select Changed

CalculatedFields

Methods Status
Add Changed

CalculatedItems

Methods Status
Add Changed

Characters

Methods Status
Delete Changed

Insert Changed

Chart

Properties Status
Area3DGroup Hidden
Bar3DGroup Hidden
Column3DGroup Hidden
Corners Hidden
Line3DGroup Hidden
Pie3DGroup Hidden
ProtectGoalSeek Hidden
ShowWindow Hidden
SizeWithWindow Hidden
SurfaceGroup Hidden
WallsAndGridlines2D Hidden
Methods Status
ApplyCustomType Hidden
ApplyDataLabels Changed

AreaGroups Hidden
BarGroups Hidden
CheckSpelling Changed

ColumnGroups Hidden
CreatePublisher Hidden
Deselect Hidden
DoughnutGroups Hidden
LineGroups Hidden
PieGroups Hidden
PrintOut Changed

RadarGroups Hidden
SaveAs Changed

XYGroups Hidden
Events Status
BeforeDoubleClick Changed

DragOver Hidden
DragPlot Hidden
MouseDown Changed

MouseMove Changed

MouseUp Changed

Select Changed

ChartArea

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden
Methods Status
Clear Changed

ClearContents Changed

ClearFormats Changed

Copy Changed

Select Changed

ChartColorFormat

Hidden

ChartFillFormat

Hidden

ChartObject

Properties Status
Border Hidden
Enabled Hidden
Interior Hidden
Methods Status
Activate Changed

BringToFront Changed

Copy Changed

CopyPicture Changed

Cut Changed

Delete Changed

Select Changed

SendToBack Changed

ChartObjects

Properties Status
Border Hidden
Enabled Hidden
Interior Hidden
RoundedCorners Hidden
Shadow Hidden
Methods Status
BringToFront Hidden
Copy Changed

CopyPicture Changed

Cut Changed

Delete Changed

Select Changed

SendToBack Hidden

Charts

Methods Status
PrintOut Changed

ChartTitle

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden
Methods Status
Delete Changed

Select Changed

Corners

Hidden

DataLabel

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden
Type Hidden
Methods Status
Delete Changed

Select Changed

DataLabels

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden
Type Hidden
Methods Status
Delete Changed

Select Changed

DataTable

Properties Status
AutoScaleFont Hidden

DownBars

Properties Status
Border Hidden
Fill Hidden
Interior Hidden
Methods Status
Delete Changed

Select Changed

DropLines

Methods Status
Delete Changed

Select Changed

ErrorBars

Methods Status
ClearFormats Changed

Delete Changed

Select Changed

Filter

Properties Status
Operator Changed

Floor

Properties Status
Border Hidden
Fill Hidden
Interior Hidden
Methods Status
ClearFormats Changed

Select Changed

Font

Properties Status
OutlineFont Hidden
Shadow Hidden

FormatCondition

Methods Status
Modify Changed

FormatConditions

Methods Status
Add Changed

Item Changed

Gridlines

Methods Status
Delete Changed

Select Changed

HiLoLines

Methods Status
Delete Changed

Select Changed

Hyperlinks

Methods Status
Add Changed

Legend

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden
Methods Status
Clear Changed

Delete Changed

Select Changed

LegendEntry

Properties Status
AutoScaleFont Hidden
Methods Status
Delete Changed

Select Changed

LegendKey

Properties Status
Border Hidden
Fill Hidden
Interior Hidden
PictureUnit Hidden
Methods Status
ClearFormats Changed

Delete Changed

Select Hidden

OLEObject

Methods Status
Activate Changed

BringToFront Changed

Copy Changed

CopyPicture Changed

Cut Changed

Delete Changed

Select Changed

SendToBack Changed

Update Changed

Verb Changed

OLEObjects

Methods Status
BringToFront Changed

Copy Changed

CopyPicture Changed

Cut Changed

Delete Changed

Select Changed

SendToBack Changed

Outline

Methods Status
ShowLevels Changed

PageSetup

Properties Status
ChartSize Hidden
Methods Status
PrintQuality Removed

Pane

Methods Status
Activate Changed

LargeScroll Changed

SmallScroll Changed

PivotCache

Properties Status
Sql Hidden

PivotField

Properties Status
CurrentPage Changed

Parent Changed

Methods Status
AutoSort Changed

Subtotals Removed

PivotFormulas

Methods Status
Add Changed

PivotTable

Properties Status
HasAutoFormat Hidden
TableStyle Hidden
Methods Status
AddFields Changed

PivotFormulas Removed
PivotSelect Changed

ShowPages Changed

PlotArea

Properties Status
Border Hidden
Fill Hidden
InsideHeight Changed

InsideLeft Changed

InsideTop Changed

InsideWidth Changed

Interior Hidden
Methods Status
ClearFormats Changed

Select Changed

Point

Properties Status
Border Hidden
Fill Hidden
Interior Hidden
PictureUnit Hidden
Methods Status
ApplyDataLabels Changed

ClearFormats Changed

Copy Changed

Delete Changed

Paste Changed

Select Changed

QueryTable

Properties Status
HasAutoFormat Hidden
Sql Hidden
TablesOnlyFromHTML Hidden

Range

Properties Status
FormulaLabel Hidden
Value Changed

Methods Status
Activate Changed

AdvancedFilter Changed

ApplyNames Changed

ApplyOutlineStyles Changed

AutoFill Changed

AutoFilter Changed

AutoFit Changed

AutoFormat Hidden
AutoOutline Changed

BorderAround Changed

Calculate Changed

CheckSpelling Changed

Clear Changed

ClearContents Changed

ClearFormats Changed

ClearNotes Changed

ClearOutline Changed

Consolidate Changed

Copy Changed

CopyPicture Changed

CreateNames Changed

CreatePublisher Hidden
Cut Changed

DataSeries Changed

Delete Changed

FillDown Changed

FillLeft Changed

FillRight Changed

FillUp Changed

Find Changed

FunctionWizard Changed

GoalSeek Hidden
Insert Changed

Justify Changed

ListNames Changed

NavigateArrow Changed

Parse Changed

PasteSpecial Changed

PrintOut Changed

PrintPreview Changed

RemoveSubtotal Changed

Replace Changed

Select Changed

Show Changed

ShowDependents Changed

ShowErrors Changed

ShowPrecedents Changed

Sort Changed

SortSpecial Changed

SubscribeTo Changed

Subtotal Changed

Table Changed

TextToColumns Changed

Ungroup Changed

RoutingSlip

Methods Status
Recipients Removed
Reset Changed

Scenario

Methods Status
ChangeScenario Changed

Delete Changed

Show Changed

Scenarios

Methods Status
CreateSummary Changed

Merge Changed

Series

Properties Status
Border Hidden
Fill Hidden
Interior Hidden
PictureUnit Hidden
Methods Status
ApplyCustomType Hidden
ApplyDataLabels Changed

ClearFormats Changed

Copy Changed

Delete Changed

ErrorBar Changed

Paste Changed

Select Changed

SeriesCollection

Methods Status
Extend Changed

Paste Changed

SeriesLines

Methods Status
Delete Changed

Select Changed

Sheets

Methods Status
PrintOut Changed

SoundNote

Methods Status
Delete Changed

Import Changed

Play Changed

Record Changed

Style

Methods Status
Delete Changed

Styles

Methods Status
Merge Changed

TickLabels

Properties Status
AutoScaleFont Hidden
Methods Status
Delete Changed

Select Changed

Trendline

Properties Status
Backward Hidden
Forward Hidden
Methods Status
ClearFormats Changed

Delete Changed

Select Changed

UpBars

Properties Status
Border Hidden
Fill Hidden
Interior Hidden
Methods Status
Delete Changed

Select Changed

Walls

Properties Status
Border Hidden
Fill Hidden
Interior Hidden
Methods Status
ClearFormats Changed

Select Changed

Window

Methods Status
Activate Changed

ActivateNext Changed

ActivatePrevious Changed

Close Changed

LargeScroll Changed

PrintOut Changed

PrintPreview Changed

ScrollWorkbookTabs Changed

SmallScroll Changed

Windows

Methods Status
Arrange Changed

Workbook

Properties Status
AcceptLabelsInFormulas Hidden
CommandBars Changed

ConflictResolution Changed

DisplayDrawingObjects Changed

HasRoutingSlip Hidden
ReadOnlyRecommended Changed

Routed Hidden
RoutingSlip Hidden
VBProject Changed

Methods Status
PrintOut Changed

ProtectSharing Changed

Route Hidden
SaveAs Changed

Workbooks

Methods Status
Open Changed

OpenText Changed

Worksheet

Methods Status
CheckSpelling Changed

PasteSpecial Changed

PrintOut Changed

Protect Changed

SaveAs Changed

Worksheets

Methods Status
PrintOut Changed

XlDisplayShapes

Constants Status
XlDisplayShapes Removed
xlHide Removed
xlPlaceholders Removed


Community Additions

Show:
© 2016 Microsoft