Object Model Changes Since Microsoft Office 2003

Excel Developer Reference

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

Application

Properties Status
FileFind Hidden
FileSearch Hidden
Methods Status
AddChartAutoFormat Hidden
DeleteChartAutoFormat Hidden
SetDefaultChart Hidden

AxisTitle

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden

Chart

Properties Status
Area3DGroup Hidden
Bar3DGroup Hidden
Column3DGroup Hidden
Corners Hidden
HasPivotFields Hidden
Line3DGroup Hidden
Pie3DGroup Hidden
ProtectGoalSeek Hidden
Scripts Hidden
ShowWindow Hidden
SizeWithWindow Hidden
SurfaceGroup Hidden
WallsAndGridlines2D Hidden
Methods Status
ApplyCustomType Hidden
AreaGroups Hidden
BarGroups Hidden
ColumnGroups Hidden
CreatePublisher Hidden
Deselect Hidden
DoughnutGroups Hidden
LineGroups Hidden
PieGroups Hidden
RadarGroups Hidden
XYGroups Hidden
Events Status
DragOver Hidden
DragPlot Hidden

ChartArea

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden

ChartColorFormat

Hidden

ChartFillFormat

Hidden

ChartObject

Properties Status
Border Hidden
Enabled Hidden
Interior Hidden

ChartObjects

Properties Status
Border Hidden
Enabled Hidden
Interior Hidden
RoundedCorners Hidden
Shadow Hidden
Methods Status
BringToFront Hidden
SendToBack Hidden

ChartTitle

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden

Corners

Hidden

CubeField

Properties Status
Caption Changed
HiddenLevels Hidden
Methods Status
AddMemberPropertyField Changed

DataLabel

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden
Type Hidden

DataLabels

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden
Type Hidden

DataTable

Properties Status
AutoScaleFont Hidden

Diagram

Hidden

DiagramNode

Hidden

DiagramNodeChildren

Hidden

DiagramNodes

Hidden

DisplayUnitLabel

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden

DownBars

Properties Status
Border Hidden
Fill Hidden
Interior Hidden

Filter

Properties Status
Operator Changed

Floor

Properties Status
Border Hidden
Fill Hidden
Interior Hidden

Font

Properties Status
OutlineFont Hidden
Shadow Hidden

FormatCondition

Methods Status
Modify Changed

FormatConditions

Methods Status
Add Changed
Item Changed

Legend

Properties Status
AutoScaleFont Hidden
Border Hidden
Fill Hidden
Font Hidden
Interior Hidden

LegendEntry

Properties Status
AutoScaleFont Hidden

LegendKey

Properties Status
Border Hidden
Fill Hidden
Interior Hidden
PictureUnit Hidden
Methods Status
Select Hidden

ListColumn

Properties Status
ListDataFormat Hidden
SharePointFormula Hidden

ListObject

Methods Status
UpdateChanges Hidden

ListObjects

Methods Status
Add Changed

ListRow

Properties Status
InvalidData Hidden

ListRows

Methods Status
Add Changed

PageSetup

Properties Status
ChartSize Hidden

PivotCaches

Methods Status
Add Hidden

PivotField

Methods Status
AutoSort Changed

PivotTable

Properties Status
HasAutoFormat Hidden
ShowCellBackgroundFromOLAP Hidden
TableStyle Hidden
Methods Status
Format Hidden

PlotArea

Properties Status
Border Hidden
Fill Hidden
InsideHeight Changed
InsideLeft Changed
InsideTop Changed
InsideWidth Changed
Interior Hidden

Point

Properties Status
Border Hidden
Fill Hidden
Interior Hidden
PictureUnit Hidden

Range

Properties Status
FormulaLabel Hidden
Methods Status
AutoFormat Hidden
CreatePublisher Hidden
GoalSeek Hidden

Series

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

Shape

Properties Status
Diagram Hidden
DiagramNode Hidden
HasDiagram Hidden
HasDiagramNode Hidden
Script Hidden

ShapeRange

Properties Status
Diagram Hidden
DiagramNode Hidden
HasDiagram Hidden
HasDiagramNode Hidden

Shapes

Methods Status
AddDiagram Hidden

Sheets

Methods Status
PrintOut Changed

TickLabels

Properties Status
AutoScaleFont Hidden

Trendline

Properties Status
Backward Hidden
Forward Hidden

UpBars

Properties Status
Border Hidden
Fill Hidden
Interior Hidden

Walls

Properties Status
Border Hidden
Fill Hidden
Interior Hidden

Workbook

Properties Status
AcceptLabelsInFormulas Hidden
HasRoutingSlip Hidden
HTMLProject Hidden
Routed Hidden
RoutingSlip Hidden
Methods Status
CheckIn Changed
PrintOut Changed
ProtectSharing Changed
Route Hidden

Worksheet

Properties Status
Scripts Hidden
Methods Status
PrintOut Changed

Worksheets

Methods Status
PrintOut Changed