Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Undo list
I've just discovered the Application.OnUndo command, and written an undo
procedure for my macro. Is there a way to not have the existing stack of undo commands cleared when code runs. ie: If there are already some items in the Undo list, I'd like my undo procedure added to the list rather than it replacing whatever's there. Thanks Rob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Undo list
Many macro commands (probably most) clear the undo stack - probably any that
would affect the ability of excel to undo. In general, Undo will not undo changes made by macros. -- Regards, Tom Ogilvy "Rob" wrote in message ... I've just discovered the Application.OnUndo command, and written an undo procedure for my macro. Is there a way to not have the existing stack of undo commands cleared when code runs. ie: If there are already some items in the Undo list, I'd like my undo procedure added to the list rather than it replacing whatever's there. Thanks Rob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Undo list
Thank you Tom.
....but everything I'm dealing with here is Undo-able: I've got the undo command to work with with my macro, and the actions that were in my undo stack before I ran "PerformSomeActions" must also be Undo-able, so surely there must be a way to leave those items in the undo stack. Is it posible to directly manipulate the Undo stack for example?? sub PerformSomeActions 'code to store some info about the initial state 'code to perform the actions application.onundo "Undo the Actions", "UndoProcedure" end sub sub UndoProcedure 'code to restore initial state end sub "Tom Ogilvy" wrote: Many macro commands (probably most) clear the undo stack - probably any that would affect the ability of excel to undo. In general, Undo will not undo changes made by macros. -- Regards, Tom Ogilvy "Rob" wrote in message ... I've just discovered the Application.OnUndo command, and written an undo procedure for my macro. Is there a way to not have the existing stack of undo commands cleared when code runs. ie: If there are already some items in the Undo list, I'd like my undo procedure added to the list rather than it replacing whatever's there. Thanks Rob |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Undo list
so surely
there must be a way to leave those items in the undo stack. I would guess not, particularly if you use onUndo Is it posible to directly manipulate the Undo stack for example?? Not that I am aware of. -- Regards, Tom Ogilvy "Rob" wrote in message ... Thank you Tom. ...but everything I'm dealing with here is Undo-able: I've got the undo command to work with with my macro, and the actions that were in my undo stack before I ran "PerformSomeActions" must also be Undo-able, so surely there must be a way to leave those items in the undo stack. Is it posible to directly manipulate the Undo stack for example?? sub PerformSomeActions 'code to store some info about the initial state 'code to perform the actions application.onundo "Undo the Actions", "UndoProcedure" end sub sub UndoProcedure 'code to restore initial state end sub "Tom Ogilvy" wrote: Many macro commands (probably most) clear the undo stack - probably any that would affect the ability of excel to undo. In general, Undo will not undo changes made by macros. -- Regards, Tom Ogilvy "Rob" wrote in message ... I've just discovered the Application.OnUndo command, and written an undo procedure for my macro. Is there a way to not have the existing stack of undo commands cleared when code runs. ie: If there are already some items in the Undo list, I'd like my undo procedure added to the list rather than it replacing whatever's there. Thanks Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I clear UNDO list? | Excel Worksheet Functions | |||
Named data validation list- how to undo? | Excel Discussion (Misc queries) | |||
Excel 07 undo list | Excel Discussion (Misc queries) | |||
Undo List | Excel Discussion (Misc queries) | |||
How do I undo a list I've created in Excel 2003? | Excel Worksheet Functions |