Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet_Change - NEW to VBA | Excel Worksheet Functions | |||
UNDO - how many times can I UNDO? | Excel Worksheet Functions | |||
Why is my undo function in Excel only can undo the last 1 or 2 ch. | Excel Worksheet Functions | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming |