Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
use macro and allow undo
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
use macro and allow undo
Hi Ben
Sorry, you can not undo any macro operation.... Regards, Per¨ "ben" skrev i meddelelsen ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
use macro and allow undo
On Sun, 30 Nov 2008 02:50:54 -0500, ben wrote:
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 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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
use macro and allow undo
Hi,
Have a look at this article http://www.jkp-ads.com/articles/UndoWithVBA00.asp Cheers Andy ben wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Undo a Macro | Excel Discussion (Misc queries) | |||
Paste Special Macro - can't undo | New Users to Excel | |||
Does Excel 2000 have an undo function after using a macro? | Excel Worksheet Functions | |||
Running of Worksheet Change Macro breaks undo functionality. | Excel Discussion (Misc queries) | |||
Can I set-up a macro to undo a previously run macro? | Excel Discussion (Misc queries) |