Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default 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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA procedure when new sheet added event shays Excel Programming 5 June 4th 07 08:48 PM
Workbook Open Event not triggering Mike Jerakis[_2_] Excel Programming 3 January 3rd 06 09:12 PM
workbooks.open without triggering event Vobiscum[_3_] Excel Programming 2 June 24th 05 07:21 AM
Triggering an event based on reference Supriya Excel Programming 0 January 29th 04 11:50 AM
Triggering click event of a menu in vba steve Excel Programming 4 August 19th 03 06:17 PM


All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"