Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Feb 2007
    Thanked 0 Times in 0 Posts

    Excel VBA (Office 2003)

    Is there a macro that undoes any previously executed macro? I have a spreadsheet that has three command buttons. The first tidies up the rows that don't figure into the totalling and Hans has helped me with that one. The second should undo what the first macro did and the third should reload the template. I've included the file.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Excel VBA (Office 2003)

    Unfortunately, running a macro in Excel clears the undo stack. If you want to be able to undo the actions of a macro, you have to write clumsy undo code yourself. See Excel Developer Tip: Undoing a VBA Subroutine.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts