Triggering an event whenever a new shape is added in a sheet
 

How would I do that guys? This is really urgent and I have already spent two
days on it. Even if I get a little clue, I could work towards achieving this!

Triggering an event whenever a new shape is added in a sheet
 

If you spend another two days trying such an event you will get closer to
finding it under the rainbow! Seriously though, no such event exists.

A partial workaround might be to maintain a list or collection of existing
shapes and compare periodically or in other events. If you are looking for
manually inserted shapes, typically after the insert user re-selects the
sheet triggering a selection change (if not same as previous active cell.).
Perhaps also look into trapping the click events of buttons on the toolbar
that user selects to insert a shape, then check the selection soon after. Of
course not all shapes are inserted via the Drawing toolbar.

A lot of work, unlikely to be accurate in real time but should be able to
catch up.

Regards,
Peter T
"Sagittarian" wrote in message
...
How would I do that guys? This is really urgent and I have already spent
two
days on it. Even if I get a little clue, I could work towards achieving
this!