View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams[_2_] Tim Williams[_2_] is offline
external usenet poster
 
Posts: 298
Default How do you get a parent collection object to listen to all if it's child objects?

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