To run a macro when the Updated event occurs, set the OnUpdated property to the name of the macro.
You can use an Updated macro to display a message whenever an OLE object’s data has been updated. However, macros can’t return the code that determines how the OLE object was updated, so you typically use event procedures with this event.
You can’t use the CancelEvent action in an Updated macro.
Updated Event — Event Procedures.