Create an Undo

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

Thanks for taking the time to read my question.

I am creating macros to do some work. However, Excel's
Undo button cannot undo what my macro has done.

Is it possible to create an undo macro to undo the
changes made by another macro?

Thanks so much for your help,

Brad
 
Hi
this would be difficult. You have to manually store in your first macro
somethere the worksheet stae before applying your macro. And afterwards
create a second macro which will return to this old state. Note: any
changes made between those two macros manually are lost in this case.
 
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 approach 3
Change cell backgrounds from VBA with undo enabled 3
Undo button in the context menu (right click menu) 7
undoing the for next procedure 4
Undo list 3
where to place undo-function in vsto-projects? 4
Change Event and undo stack 2
How do I create a Reset Button on a form created in Excel 1

Back
Top