Results 1 to 3 of 3

Thread: Undo (2002)

  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Undo (2002)

    I use the attached code on two specific workbooks that use the recalculation event to highlight filtered columns. It works exactly as required and is extremely useful. However, the major drawback with this is that Excel's undo feature becomes completely useless in every open workbook when this (these) workbook(s) are open. Is there a way around this??
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Undo (2002)

    You'd have to program an Undo capability explicitly; this is very tedious.
    See:
    Undo With Excel VBA by our own Jan Karel Pieterse.
    Spreadsheet Page Excel Tips: Undoing A VBA Subroutine by John Walkenbach.

  3. #3
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Undo (2002)

    <hr>You'd have to program an Undo capability explicitly; this is very tedious.<hr>
    I feared as much!!

    I remember John Walkenbach's comment (VBA for Dummies) that although possible, it was beyond the scope of that particular book.

    Many Thanks for the links!

Posting Permissions

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