Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mimic Undo actions
Hi,
Does anyone have a procedure or knows how to jury-rig a function that can mimic the undo action, that will allow you to return the worksheet back to its state prior to programmaticly made changes. I cannot use a simple, Close/don't-save-changes routine, because I want to keep the form active and its values and all the underlying variables unchanged. Any help will be greatly apprecaited. Thanks all. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mimic Undo actions
Hi,
I guess one way is to make a copy of the original sheet and keep it xlSheetVeryHidden. Hth OJ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mimic Undo actions
Visit John Walkenbach's site:
http://www.j-walk.com/ss/excel/tips/tip23.htm for one method. "Chris W." wrote: Hi, Does anyone have a procedure or knows how to jury-rig a function that can mimic the undo action, that will allow you to return the worksheet back to its state prior to programmaticly made changes. I cannot use a simple, Close/don't-save-changes routine, because I want to keep the form active and its values and all the underlying variables unchanged. Any help will be greatly apprecaited. Thanks all. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mimic a watermark | Excel Discussion (Misc queries) | |||
Undo multiple actions | Excel Discussion (Misc queries) | |||
mimic Working Days in ATP | Excel Programming | |||
Why is my undo function in Excel only can undo the last 1 or 2 ch. | Excel Worksheet Functions | |||
Mimic Value Being Typed Into Cell | Excel Programming |