Worksheet_Change & Undo
 

Hi. I have written a macro to activate on
Worksheet_Change. This is working great, but one problem
I have is that the "Undo" function won't work any time
the code is executed. Is there a way around this?

Thanks,
Mike.

Worksheet_Change & Undo
 

Mike,

Is there a way around this?
Take a look he

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

John


"Mike" wrote in message
...
Hi. I have written a macro to activate on
Worksheet_Change. This is working great, but one problem
I have is that the "Undo" function won't work any time
the code is executed. Is there a way around this?

Thanks,
Mike.

Worksheet_Change & Undo
 

Start the macro with:

ThisWorkbook.Save

It will take a few seconds, but you'll always be able to revert to you
saved version from before the rest of the macro ran. This won't be to
hot if the macro is run very often, and I'm sure there's a mor
effective answer, but this will do in a pinch. - Piku

--
Message posted from http://www.ExcelForum.com

Worksheet_Change & Undo
 

Thanks, John. I will take a look ...
-----Original Message-----
Mike,

Is there a way around this?
Take a look he

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

John


"Mike" wrote in
message
...
Hi. I have written a macro to activate on
Worksheet_Change. This is working great, but one
problem
I have is that the "Undo" function won't work any time
the code is executed. Is there a way around this?

Thanks,
Mike.


.

Worksheet_Change & Undo
 

Thanks, Pikus. John (above) has also pointed me to
another possible solution. This macro will actually be
executed very frequently.

Mike.

-----Original Message-----
Start the macro with:

ThisWorkbook.Save

It will take a few seconds, but you'll always be able to
revert to your
saved version from before the rest of the macro ran.
This won't be too
hot if the macro is run very often, and I'm sure there's
a more
effective answer, but this will do in a pinch. - Pikus


---
Message posted from http://www.ExcelForum.com/

.