Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UNDO in VBA code???
Okay, I wrote this really cool function, you see. It populates tons of blank
cells for the end-users, saving them hour upon hours of time. Everyone's happy....except.... The function updates a bunch of data, but the "Undo" button is never activated. So, if the want to undo the data changed by my way-cool function, the only way for them to do it is to close the file without saving changes and re-open it. How do I get my code to activate the "Undo" button, so the changes can be rolled back if needed? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
UNDO in VBA code???
Joel,
When you run a procedure, the Undo buffer is cleared; previous commands cannot be undone. You can create your own Undo procedure, but when you go to Undo in the Excel UI, only this procedure is available. Use Application.OnUndo to assign a procedure to the Undo action. E.g., Public Sub AAA() Application.OnUndo "Undo This", "UndoProc" ' your code here End Sub Sub UndoProc() ' code to undo End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Joel" wrote in message ... Okay, I wrote this really cool function, you see. It populates tons of blank cells for the end-users, saving them hour upon hours of time. Everyone's happy....except.... The function updates a bunch of data, but the "Undo" button is never activated. So, if the want to undo the data changed by my way-cool function, the only way for them to do it is to close the file without saving changes and re-open it. How do I get my code to activate the "Undo" button, so the changes can be rolled back if needed? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
UNDO in VBA code???
Simple answer, macros can not be undone, you'll have to write a roll back
feature into your macro. ben "Joel" wrote: Okay, I wrote this really cool function, you see. It populates tons of blank cells for the end-users, saving them hour upon hours of time. Everyone's happy....except.... The function updates a bunch of data, but the "Undo" button is never activated. So, if the want to undo the data changed by my way-cool function, the only way for them to do it is to close the file without saving changes and re-open it. How do I get my code to activate the "Undo" button, so the changes can be rolled back if needed? Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
UNDO in VBA code???
Save the cells before the cool function kicks in, and provide a facility
that re-instates the data. -- HTH RP (remove nothere from the email address if mailing direct) "Joel" wrote in message ... Okay, I wrote this really cool function, you see. It populates tons of blank cells for the end-users, saving them hour upon hours of time. Everyone's happy....except.... The function updates a bunch of data, but the "Undo" button is never activated. So, if the want to undo the data changed by my way-cool function, the only way for them to do it is to close the file without saving changes and re-open it. How do I get my code to activate the "Undo" button, so the changes can be rolled back if needed? Thanks! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
UNDO in VBA code???
John Walkenbach has some tips, too:
http://www.j-walk.com/ss/excel/tips/tip23.htm Joel wrote: Okay, I wrote this really cool function, you see. It populates tons of blank cells for the end-users, saving them hour upon hours of time. Everyone's happy....except.... The function updates a bunch of data, but the "Undo" button is never activated. So, if the want to undo the data changed by my way-cool function, the only way for them to do it is to close the file without saving changes and re-open it. How do I get my code to activate the "Undo" button, so the changes can be rolled back if needed? Thanks! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code to undo previous VBA action | Excel Discussion (Misc queries) | |||
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 | |||
undo in code | Excel Programming | |||
Setting Font properties in Code clears Undo list | Excel Programming |