Hi

When deleting a shape in Excel, I was wondering if there is a way to fire an event similar to the Visio BeforeDeleteShape event (http://msdn.microsoft.com/en-us/libr...ffice.11).aspx)?

(FWIW, I'm using Excel 2003 at the moment)

Slightly more particularly, there is some tidy up that needs to be done if someone deletes a particular chart from a sheet and it would be good if it occurred at the time the chart is deleted (without the need to manually run a clean up routine). As deleting a shape object isn't effecting a range it doesn't seem to fire any sheet events?

As there are no shape-specific MouseUp/KeyUp events that I know of, I can approximate it using the OnAction property (eg wkbk.shp.OnAction = "CheckIfNextKeystrokeIsDelete") but that is far from ideal.

Any thoughts or assistance much appreciated.

Thanks,
D.