use macro and allow undo

  • Thread starter Thread starter ben
  • Start date Start date
B

ben

Hello.

I have a macro that I recorded which works great. It does a copy and special
paste to another work sheet. The only problem is that after it has run, if I
made some kind of mistake and it copied the wrong stuff (or whatever), I
cannot click on undo or alt-backspace. Is there anyway that the copy and
paste of the macro can be undone this way?

Thanks,
Ben
 
Hello.

I have a macro that I recorded which works great. It does a copy and special
paste to another work sheet. The only problem is that after it has run, if I
made some kind of mistake and it copied the wrong stuff (or whatever), I
cannot click on undo or alt-backspace. Is there anyway that the copy and
paste of the macro can be undone this way?

Thanks,
Ben
Click to expand...


You have to build that into the macro itself.
The macro must save, "somewhere", all data that will be modified by
the macro.
And then you must have another "undo" macro that restores data from
"somewhere".

/ Lars-Åke
 
Back
Top