+ Reply to Thread
Results 1 to 4 of 4

About Application.Run and disable ScreenUpdating

Hybrid View

  1. #1
    Registered User
    Join Date
    11-17-2021
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    18

    About Application.Run and disable ScreenUpdating

    Hello masters,

    I am using Application.Run in my workbook to call a macro from another workbook.
    I read documents stating I have to use Application.Run "file.xlsm!macro"
    It is working like a charm, but here is my questions:

    1- This will open the file and execute the macro. It seems "ScreenUpdating = Off" does not work
    Is there any other alternative?


    This will open the file and "needs to close the file when done", such as workbooks.close.

    So ScreenUpdating = Off would make the whole experience a lot cleaner, no more pop up programs (open/close) of screen flickering.

    Please advise.

    Thank you!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,507

    Re: About Application.Run and disable ScreenUpdating

    It seems "ScreenUpdating = Off" does not work
    Is there any other alternative?
    Why do you say that?
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    11-17-2021
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    18

    Re: About Application.Run and disable ScreenUpdating

    Because I have put Application.ScreenUpdating = OFF, and it is not OFF at all.

    When you execute Application.Run it will open the file.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,507

    Re: About Application.Run and disable ScreenUpdating

    If you step through the code manually using F8, it doesn't work. Other than that, it should.


    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Application.ScreenUpdating = False
    By Gero92 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2018, 02:34 AM
  2. [SOLVED] Application.EnableEvents and Application.ScreenUpdating doubt
    By no_Fate in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-04-2017, 01:18 PM
  3. [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
  4. 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
  5. [SOLVED] Application.screenupdating
    By teachMeExcel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2012, 04:26 PM
  6. Application.ScreenUpdating
    By royUK in forum Tips and Tutorials
    Replies: 3
    Last Post: 05-13-2008, 04:18 AM
  7. PLEASE PLEASE HELP Application.Screenupdating
    By modjoe23 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-03-2005, 01:05 AM

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