Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Dec 2004
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro flickering (Excel/VBA 2002)

    When I run a macro, the screen flickers to indicate that the macro is running. How can I get rid of the flickering? However, for some I do want the flickering to occur. Can I get rid of it for some macros and have it flicker for others in the same workbook?

    Thank you.

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Macro flickering (Excel/VBA 2002)

    You can set Application.ScreenUpdating = False, but make sure that every possible exit path from your code sets it back to True again.

    StuartR

  3. #3
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Macro flickering (Excel/VBA 2002)

    Stuart's solution will work for you, but can I add that the flickering may indicate unnecessary activation and selection of workbooks, worksheets and ranges/cells. Efficient Excel macro code works on these objects without the need to activate or select them; it will run much faster. (There are a few exceptions where activation is necessary, mostly related to the Window and Print selection object groups.)

    If you would like to post some short snippets of the code, a Lounger might be willing to suggest improvements. Also, Excel VBA 'how-to' books explain how to address the objects without using activate or select.
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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