Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA procedure when new sheet added event | Excel Programming | |||
Workbook Open Event not triggering | Excel Programming | |||
workbooks.open without triggering event | Excel Programming | |||
Triggering an event based on reference | Excel Programming | |||
Triggering click event of a menu in vba | Excel Programming |