Hi All

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

Thanks a million
Kike

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

Hi Andy
Thanks for the suggestion. I had already tried that. The problem is every
time the user selects a different chart or a cell the chart fires the
Deactivate event... although the chart is still there. So I'm not sure I can
make it work that way.
I'm not versed in VBA. Im much more used to other languages. It is hard to
believe that no event is fired when an object is deleted. Is there a way to
trap event through lower level code?

Cheers
Kike


"Andy Pope" wrote:

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

Hi,

There are many events that are not catered for not just chart deletion.
If there is lower level code I do not know it.

Cheers
Andy

El vengador de la capa wrote:
Hi Andy
Thanks for the suggestion. I had already tried that. The problem is every
time the user selects a different chart or a cell the chart fires the
Deactivate event... although the chart is still there. So I'm not sure I can
make it work that way.
I'm not versed in VBA. Im much more used to other languages. It is hard to
believe that no event is fired when an object is deleted. Is there a way to
trap event through lower level code?

Cheers
Kike


"Andy Pope" wrote:


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


--

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