Mimic Undo actions

  • Thread starter Thread starter Chris W.
  • Start date Start date
C

Chris W.

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.
 
Hi,
I guess one way is to make a copy of the original sheet and keep it
xlSheetVeryHidden.

Hth
OJ
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Undo VB macro action 1
Undo a scroll action 6
problem with undo and a user form 1
Mimic Print Preview? 1
Undo Command Button Actions 1
Why Undo commandbutton is Cleared ? 5
Change cell backgrounds from VBA with undo enabled 3
How can i insert data into sheet without going thruogh the undo buffer ? 1

Back
Top