Hi Tushar,

Must admit I never tested for selected or multiple object deleting :)

Cheers
Andy


Tushar Mehta wrote:
Hi Andy,

That's a nice idea -- with limited applicability. If someone selects
the chartobject (or selects multiple charts which causes XL to
automatically select the associated chartobjects), the Deactivate event
is not triggered.

The only way that I have been able to think of to detect with certainty
the creation of new charts and the deletion of existing charts is to
have MS enhance the XL object model (or, of course, use a timer, which
can have its own set of issues).


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info