Cannot Undo After Running Macro

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Whenever I have run a macro I am unable to Edit>Undo the action that the
macro has carried out.

Does anyone know how to get around this? Thanks
 
Well, the standard Undo command won't work if the change is through a macro.

If you want to Undo the changes done by macro, you will have to write your
own code for that.

Sharad
 
Suggest making a copy of the worksheet/workbook before you run the macro for
the reasons already stated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
undo a macro 1
Undo VB macro action 1
Call Paste function with Undo 2
Undo approach 3
Unable to unassign macro from shape 4
Question about the Queue of Commands in Undo 1
Macro code to clipboard 2

Back
Top