Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Can't Undo in file? (Excel 2000 >)

    Hi,

    This file has a SelectionChange event macro that changes the row height! Also a conditional format that alternates the row colour! (These are the only "special" features in an otherwise normal file!) Why can't I undo? The Undo button stays gray!???
    Regards,
    Rudi

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

    Re: Can't Undo in file? (Excel 2000 >)

    Macro code execution clears the undo stack. Each time you move to another cell, the Worksheet_SelectionChange event procedure is executed, and hence the undo stack is cleared.

Posting Permissions

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