See:
http://www.cpearson.com/excel/Events.aspx
Down towards the bottom of the page.
Tim
"Ronald R. Dodge, Jr." wrote in message
...
I am looking for a way of getting a parent collection object to be able to
hear all of it's child objects via events similar to how the Workbooks
Event of "SheetChange" work in listening to when there's a change to any of
it's sheets. How can I setup a such mechanism?
--
Thanks,
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000