?
Solved

how to get back after running a macro

Posted on 2011-04-27
2
Medium Priority
?
215 Views
Last Modified: 2012-08-13
I run a macro and I cannot get back to my old data because they where erase ?Ctrl + Z didn't work ? thank u
0
Comment
Question by:sharkyboy
  • 2
2 Comments
 
LVL 21

Expert Comment

by:Alan
ID: 35480997
Hi,

Two options:

1) Close, but don't save changes to the file, then re-open and it will be back where you started from.

2) Do you have a backup of the file and / or data that was erased?  If so, you could copy / paste it back to the current file.

Alan.
0
 
LVL 21

Accepted Solution

by:
Alan earned 500 total points
ID: 35481002
Hi,

Just to note, that if changes are made by a macro (VBA) then 'undo' is not in effect, so you cannot 'undo' what the macro did per se.

However, whoever wrote the macro *may* have written an undo feature as a safety precaution - this is quite common, and certainly 'best practice', so have a look around to see if there is something like that.

Unfortunately, even if such 'undo' functionality has been built by the coder, it might not be available if you have saved the file.

Alan.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

840 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