Consulting

Results 1 to 4 of 4

Thread: Solved: After a macro or code is run the undo function doesn't work.

  1. #1

    Solved: After a macro or code is run the undo function doesn't work.

    Hi,

    After a macro or code is run the undo function doesn't work.

    Does anybody have a good explanation for this or a solution to undo the macro.


    Thank's
    Julio
    Life is not as complicated as we think it is, we make it complicated.

    IF you can change it, then strive for excellence.
    IF not, then let it happen, don't worry about it and live a happier life.


    Let's Have Fun!
    Julio

  2. #2
    Site Admin
    Jedi Master
    VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Well, after the macro runs, the Undo feature would have to Undo the effects of the macro first, which it can't do, so Undo is not available.

    You could create your own Undo code, but would probably be more trouble than it is worth.

    If Undo is really needed, you will need to look at when your macros are called, and if some of those calls are not needed.

  3. #3
    I have a couple of pages about creating a VBA undo system:

    www.jkp-ads.com/articles/undowithvba00.asp
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  4. #4
    Thank's
    Life is not as complicated as we think it is, we make it complicated.

    IF you can change it, then strive for excellence.
    IF not, then let it happen, don't worry about it and live a happier life.


    Let's Have Fun!
    Julio

Posting Permissions

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