Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511

    Question Unanswered: Disable UNDO Temporarily?

    Is there a way to disable UNDO in Excel 2000? I am using VBA to copy formulas from the first row of 137 columns to the following 2,600 rows. A dialog box pops up with the message that there is not enough memory...continue without undo? The copying can be completed, but I would like to know is there is a way in VBA to turn UNDO off and back on again after the copying is finished. My goal is to speed up the copying that now takes several minutes.

    Thanks.

    Jerry

  2. #2
    Join Date
    Dec 2003
    Location
    Östersund Sweden
    Posts
    60
    Jerry,

    How about:

    Application.DisplayAlerts = False
    'Your code....
    Application.DisplayAlerts = True

    Kind regards,
    Dennis
    Kind regards,
    Dennis

Posting Permissions

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