ModelChanges object (Excel)

Represents changes made to the data model.

Remarks

The ModelChanges object contains information about which changes were made to the data model when the ModelChange event of the Workbook object occurs after a model operation.

When Micrososft Excel makes changes to the data model, multiple changes can be made in the same operation, and the ModelChanges object will include information about all the changes made in one model operation.

Properties

• Application
• ColumnsAdded
• ColumnsChanged
• ColumnsDeleted
• Creator
• MeasuresAdded
• Parent
• RelationshipChange
• Source
• TableNamesChanged
• TablesAdded
• TablesDeleted
• TablesModified
• UnknownChange

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.