Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Excel VBA, Undo WorkSheet modifications, done by VBA script,

I have notice that attempting to undo modifications (line insertions / deletions etc) done by VBA script is not possible.

Is it any way to make it possible???

Thanks so much
0
New_Alex
Asked:
New_Alex
  • 3
2 Solutions
 
Chris BottomleyCommented:
Not especially but you can save a copy of the workbook first and revert that way

Chris
0
 
Rory ArchibaldCommented:
It is possible, but you have to code it yourself (or do something like Chris suggested): http://j-walk.com/ss/excel/tips/tip23.htm

Regards,
Rory
0
 
Chris BottomleyCommented:
Note by not especially what I mean is you can create code that undoes the activities for example if you modify a range of cells in code then first save the workbook, change the cells in code, do something else as much as appropriate, finally to undo the cell edits, copy the data from the copy back into the original book.

Now the cell edits are undone but the other changes have been retained.  Obviously though any undo has to be specifically coded for this approach.

Chris
0
 
Chris BottomleyCommented:
Interestingly rory's link is pretty much the exact scenario I outlined and therefore helps authenticate the situation.

Chris
0
 
New_AlexAuthor Commented:
Thankz people
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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