Does Excel 2000 have an undo function after using a macro?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joshua Jacoby - 23 May 2006 15:41 GMT

After running a macro that applies a strikethrough to all the cells I have
highlighted, it appears that I lose the "undo" or "back" function, or it
resets it. Is there any way to disable the resetting of that, or is there
any other way to undo if I run a macro and didn't really want to, and want to
return to my worksheet the way it was just before I ran the macro?

Reply to this Message

ChuckF - 23 May 2006 16:29 GMT

The easy answer is no.

Obviously if you close out the spreadsheet without saving it...it will
return your spreadsheet to the way it was last time you saved
it...which may or may not have been prior to the macro.

Sorry this isn't what you were looking for, but to my knowledge there
isn't a way to undo a macro.

Reply to this Message

JE McGimpsey - 23 May 2006 16:35 GMT

See

http://www.j-walk.com/ss/excel/tips/tip23.htm

> After running a macro that applies a strikethrough to all the cells I have
> highlighted, it appears that I lose the "undo" or "back" function, or it
> resets it. Is there any way to disable the resetting of that, or is there
> any other way to undo if I run a macro and didn't really want to, and want to
> return to my worksheet the way it was just before I ran the macro?

Reply to this Message