visual studio excel addin script actions not undoable

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/
NewtonianBAsked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
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: http://j-walk.com/ss/excel/tips/tip23.htm) and I suspect the same is true of a VS addin.
0
 
NewtonianBAuthor Commented:
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
0
 
sparabCommented:
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.
0
 
NewtonianBAuthor Commented:
Trying to object so I can accept him myself and close this
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.