+ Reply to Thread
Results 1 to 12 of 12

Application.ScreenUpdating not working

  1. 03-16-2017, 06:42 AM #1
    jimapos
    jimapos is offline
    Registered User
    Join Date
    05-20-2005
    Location
    Thessaloniki Greece
    MS-Off Ver
    2021
    Posts
    39

    Application.ScreenUpdating not working

    Hello experts

    i have this macro (which calls macros in other workbooks) and the Application.ScreenUpdating=false is not working
    Here is my code:

    Application.ScreenUpdating = False
    Workbooks("rtb_x.xlsm").Activate
    Application.Run "\\JIM\doc\LEXMARK\2017\rtb_x.xlsm!filter_all_rtb"
    Workbooks("ONSITE_X.xlsm").Activate
    Application.Run "\\JIM\doc\LEXMARK\2017\ONSITE_X.xlsm!FilterALL_ONSITE"
    Workbooks("PARTS_X.xlsm").Activate
    Application.Run "\\JIM\doc\LEXMARK\2017\PARTS_X.xlsm!FilterALL"
    Application.ScreenUpdating = True
    Workbooks("OPENWORK.xlsM").Activate

    Any ideas ?
    Reply With QuoteRegister To Reply
  2. 03-16-2017, 07:01 AM #2
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Application.ScreenUpdating not working

    Hi,

    Do any of the macros you are running set Screenupdating back to True at the end of their code?
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
  3. 03-16-2017, 07:14 AM #3
    jimapos
    jimapos is offline
    Registered User
    Join Date
    05-20-2005
    Location
    Thessaloniki Greece
    MS-Off Ver
    2021
    Posts
    39

    Re: Application.ScreenUpdating not working

    Each macro (in other workbooks) runs perfect without problem.
    with or without Application.ScreenUpdating = True (in the end of macro)
    Reply With QuoteRegister To Reply
  4. 03-16-2017, 07:25 AM #4
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Application.ScreenUpdating not working

    The point is that if you call a macro that ends with Screenupdating = True, it will cause a screen refresh in the main macro.
    Reply With QuoteRegister To Reply
  5. 03-16-2017, 07:29 AM #5
    jimapos
    jimapos is offline
    Registered User
    Join Date
    05-20-2005
    Location
    Thessaloniki Greece
    MS-Off Ver
    2021
    Posts
    39

    Re: Application.ScreenUpdating not working

    no ,this is not true i tried already
    Reply With QuoteRegister To Reply
  6. 03-16-2017, 07:45 AM #6
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Application.ScreenUpdating not working

    It is true. As soon as any code runs the line
    Please Login or Register  to view this content.
    a screen refresh will occur.
    Reply With QuoteRegister To Reply
  7. 03-16-2017, 08:10 AM #7
    jimapos
    jimapos is offline
    Registered User
    Join Date
    05-20-2005
    Location
    Thessaloniki Greece
    MS-Off Ver
    2021
    Posts
    39

    Re: Application.ScreenUpdating not working

    I mean the Screenupdating is not working.And why the 2nd macro (in other workbook) runs perfect with or without Screenupdating =true ?
    When the main macro runs it show all the process from the biggining not in the end of macro.
    Any ideas how to avoid this ?
    Reply With QuoteRegister To Reply
  8. 03-16-2017, 08:20 AM #8
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Application.ScreenUpdating not working

    Your main macro (Macro1) turns screenupdating off. If you then call another macro (macro2) that turns it back on, you will see the screen refresh at that moment. If the next called macro (macro3) doesn't turn screenupdating off again, you will see everything it does because screenupdating is still on because of macro2. If macro3 does turn screenupdating off but then turns it back on at the end, you'll see the screen redraw then. This repeats for each called macro.

    Simply removing Screenupdating = True from all the macros should resolve that.
    Reply With QuoteRegister To Reply
  9. 03-16-2017, 08:51 AM #9
    jimapos
    jimapos is offline
    Registered User
    Join Date
    05-20-2005
    Location
    Thessaloniki Greece
    MS-Off Ver
    2021
    Posts
    39

    Re: Application.ScreenUpdating not working

    Not working i'm afraid.I think this line causing the problem :
    Workbooks("rtb_x.xlsm").Activate
    Reply With QuoteRegister To Reply
  10. 03-16-2017, 09:04 AM #10
    WasWodge
    WasWodge is offline
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Application.ScreenUpdating not working

    Do you actually need to activate the workbook?
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
    Reply With QuoteRegister To Reply
  11. 03-16-2017, 09:07 AM #11
    jimapos
    jimapos is offline
    Registered User
    Join Date
    05-20-2005
    Location
    Thessaloniki Greece
    MS-Off Ver
    2021
    Posts
    39

    Re: Application.ScreenUpdating not working

    NO i only need to run a macro from this workbook
    Reply With QuoteRegister To Reply
  12. 03-16-2017, 11:09 AM #12
    WasWodge
    WasWodge is offline
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Application.ScreenUpdating not working

    Then have you tried commenting out all the activate lines to see it runs correctly without them?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Application.screenupdating True towards False isnt working
    By Fean in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-07-2016, 11:45 AM
  2. Application.Screenupdating = False - not working
    By demarc in forum Excel General
    Replies: 3
    Last Post: 05-02-2015, 11:02 AM
  3. Application.Screenupdating = false not working
    By tanvi_kalra in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 01-30-2014, 09:55 AM
  4. [SOLVED] VBA Application.EnableEvents and Application.ScreenUpdating
    By mcmunoz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-01-2013, 10:24 PM
  5. Application.ScreenUpdating not working with Application.Run
    By WaqasTariq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2012, 02:24 PM
  6. [SOLVED] Application.ScreenUpdating not working
    By UsmanBPD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-25-2012, 05:19 AM
  7. Application.screenupdating = False is not working
    By gnome_core in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-15-2009, 03:32 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1