+ Reply to Thread
Results 1 to 3 of 3

Screen flashes during VBA execution - does it happen in Office 2013?

  1. #1
    Registered User
    Join Date
    01-13-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Screen flashes during VBA execution - does it happen in Office 2013?

    Hello - I was hoping for a little help. I have a piece of code in a macro that when I run it causes my screen to briefly flash, which I do not want (as I have to execute it once a second as part of a more complex setup.) Could anyone with Office 2013 please help me by telling me if the macro provided below causes the flash in their setups, as I don't have that version - and would need to change machines to install it (which I will do if needs be but need to know first.) Many thanks.

    Edit: Setting screen update to false does not fix the problem

    The code is as follows:

    Please Login or Register  to view this content.
    Last edited by tpbeta; 01-13-2013 at 05:26 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Screen flashes during VBA execution - does it happen in Office 2013?

    Set the application.screenupdating property to false at the top of the code, and then back to true at the bottom.

    Please take a few minutes to read the forum rules, and then edit your post to add code tage.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    01-13-2013
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Screen flashes during VBA execution - does it happen in Office 2013?

    Apologies for lack of code tags. Edited.

    I have already tried the screenupdating command and it makes no difference I'm afraid.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Screen flashes during VBA execution - does it happen in Office 2013?

    Post the code you're using?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1