Hi,

There is no delete event. But you could try this.
The Deactive event is fired when you delete a chart sheet. Trouble is
the chart is still there when you are in the event so you can not tell
the difference between deactivate or delete. So you use a routine to
issue a OnTime call to another routine. Store a reference to the chart
sheet in a module level variable. The when the ontime routine runs,
about a sec or 2 later, you can check the object. If deleted it will
result in an error which you can trap.

If you intend to stop the user deleting, which is why you want to
capture the event then this will not work. Instead you could try
disabling the menu entry points in to chart deletion.

Cheers
Andy

El vengador de la capa wrote:
Hi All

Is it possible to detect an event when a chart is being deleted in vba?

Thanks a million
Kike

--

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