Does Excel 2000 have an undo function after using a macro?
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? |
Does Excel 2000 have an undo function after using a macro?
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. |
Does Excel 2000 have an undo function after using a macro?
See
http://www.j-walk.com/ss/excel/tips/tip23.htm In article , Joshua Jacoby <Joshua wrote: 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? |
All times are GMT +1. The time now is 03:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com