Thanks for taking the time to read my question.

I am creating macros to do some work. However, Excel's
Undo button cannot undo what my macro has done.

Is it possible to create an undo macro to undo the
changes made by another macro?

Thanks so much for your help,

Brad

Hi
this would be difficult. You have to manually store in your first macro
somethere the worksheet stae before applying your macro. And afterwards
create a second macro which will return to this old state. Note: any
changes made between those two macros manually are lost in this case.

--
Regards
Frank Kabel
Frankfurt, Germany


Brad wrote:
Thanks for taking the time to read my question.

I am creating macros to do some work. However, Excel's
Undo button cannot undo what my macro has done.

Is it possible to create an undo macro to undo the
changes made by another macro?

Thanks so much for your help,

Brad

Take a look he

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


In article ,
"Brad" wrote:

Thanks for taking the time to read my question.

I am creating macros to do some work. However, Excel's
Undo button cannot undo what my macro has done.

Is it possible to create an undo macro to undo the
changes made by another macro?

Thanks so much for your help,

Brad