Results 1 to 2 of 2

Thread: Freezing Excel [Resvoled]

  1. Oct 15th, 2003, 05:09 PM #1
    Maldrid
    Maldrid is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2003
    Location
    IL
    Posts
    739

    Freezing Excel [Resvoled]

    I know there is a flag I can set in code so that while a macro is running excel does not update the screen until it is done. Does anyone know what that flag is?
    Motto: Anything for a laugh.

    Getting second place only means you are the first loser to cross the finish line.
    Reply With Quote Reply With Quote
  2. Oct 15th, 2003, 05:11 PM #2
    Maldrid
    Maldrid is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jun 2003
    Location
    IL
    Posts
    739
    Ok nevermind I found it

    Application.ScreenUpdating=False
    Motto: Anything for a laugh.

    Getting second place only means you are the first loser to cross the finish line.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width