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. |
Mimic Undo actions
Hi,
I guess one way is to make a copy of the original sheet and keep it xlSheetVeryHidden. Hth OJ |
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 |
All times are GMT +1. The time now is 01:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com