visual studio excel addin script actions not undoable

Posted on 2011-04-28
Last Modified: 2012-08-14
Why are my excel addin actions not undoable? How can I get them to register so a user who runs the script has the ability to undo?

My addin writes data to cells and overwrites data if it exists however once written I can't undo/
Question by:NewtonianB
    LVL 85

    Accepted Solution

    The same is true of any code actions. In VBA you need to create an Undo version and assign that to the Application.Undo property (see example here: and I suspect the same is true of a VS addin.

    Author Comment

    Could you please accept rorya and close this. I tried to accept him and I get
    "This question already has an auto close request. You must cancel the previous request before creating another."

    And because of this question I can not ask any other questions at the moment I am stuck. Thank you
    LVL 11

    Expert Comment

    I've requested that this question be closed as follows:

    Accepted answer: 500 points for rorya's comment http:/Q_26983115.html#35484031

    for the following reason:

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Author Comment

    Trying to object so I can accept him myself and close this

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
    In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now