[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

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/
0
NewtonianB
Asked:
NewtonianB
  • 2
1 Solution
 
Rory ArchibaldCommented:
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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now