+ Reply to Thread
Results 1 to 2 of 2

Is there anything equivalent to the Visio BeforeDeleteShape in Excel?

  1. #1
    Registered User
    Join Date
    03-14-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Is there anything equivalent to the Visio BeforeDeleteShape in Excel?

    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.

  2. #2
    Registered User
    Join Date
    03-14-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Is there anything equivalent to the Visio BeforeDeleteShape in Excel?

    Thought about it further.

    I posted something approaching a solution here:

    http://www.mrexcel.com/forum/excel-q...ml#post3428258

    Thx,
    D.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1