+ Reply to Thread
Results 1 to 6 of 6

Screen Updating starts before asked to do so in procedure

  1. #1
    Registered User
    Join Date
    09-05-2014
    Location
    Atlanta
    MS-Off Ver
    2010
    Posts
    6

    Screen Updating starts before asked to do so in procedure

    Hi,

    I have many macros that run during Workbook_Open.
    If I am NOT ready to Add Progress Bar process macro, I have a sheet with message stating "Wait Till This Message Disappears" to user.

    I .select this sheet at the beginning of the macro BEFORE running the line code "Application.ScreenUpdating =false"
    But when the Workbook_Open macro runs the sheet doesn't show as it should during the run process.
    If I step through it, it does like as it should.

    My code:

    Please Login or Register  to view this content.
    After macro is run the sheet "Main Menu" shows like it should.
    But sheet with message doesn't show before screen updating is set to false

    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. We have special tags to indicate code, that preserve formatting and allow scrolling. I appreciate the effort to set off your with color, but we prefer the CODE tags. I have added them for you this time because you are a new member. --6StringJazzer
    Last edited by 6StringJazzer; 07-03-2015 at 09:34 PM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,449

    Re: Screen Updating starts before asked to do so in procedure

    There is not enough information to understand what you're doing or what the problem is. Can you attach your Excel file?

    Also, this is not your problem but why not just use
    Please Login or Register  to view this content.
    instead of
    Please Login or Register  to view this content.
    It shouldn't make a difference but the code is simpler and easier to understand.
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    09-05-2014
    Location
    Atlanta
    MS-Off Ver
    2010
    Posts
    6

    Re: Screen Updating starts before asked to do so in procedure

    Jeff,

    Show_FileLoadMessage is a private macro hence using Application.Run

    What didn't you understand about the problem?

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,541

    Re: Screen Updating starts before asked to do so in procedure

    Have you tried putting a Stop statement after your Sub declaration and then reopening the workbook and stepping through the code to see what happens?
    As a reminder, once your original request has been fulfilled please mark this thread as SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

    If you are happy with my help, then please consider clicking the add reputation button in the lower left hand corner of this post.

  5. #5
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,449

    Re: Screen Updating starts before asked to do so in procedure

    Quote Originally Posted by Skygazer... View Post
    What didn't you understand about the problem?
    I don't see how the following statement relates to the rest of your problem description or the code that you posted:
    If I am NOT ready to Add Progress Bar process macro, I have a sheet with message stating "Wait Till This Message Disappears" to user.

    I do not understand this statement:
    I .select this sheet at the beginning of the macro BEFORE running the line code "Application.ScreenUpdating =false"
    Your code does not show selecting a sheet, although you have a comment that says you select a sheet. If Show_FileLoadMessage selects a sheet, then the problem could be inside that macro.

    And this statement:
    But when the Workbook_Open macro runs the sheet doesn't show as it should during the run process.
    What is "the sheet"? There is nothing in the code you posted that causes any sheet to show.

    I still recommend that you attach your file.

  6. #6
    Forum Expert JasperD's Avatar
    Join Date
    05-07-2013
    Location
    Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    1,393

    Re: Screen Updating starts before asked to do so in procedure

    Place a doevents in there to slow it down just enough to show the sheet you want to show.

    Please Login or Register  to view this content.
    Please click the * below if this helps
    Please click the * below if this helps

+ 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. Prevent Screen Changes During Procedure
    By ezrizer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2014, 04:39 PM
  2. Replies: 4
    Last Post: 01-23-2014, 07:05 AM
  3. Screen Updating reset at end of procedure
    By anteagles20 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2013, 08:07 AM
  4. Updating the nos that starts with 2 alone
    By share knowledge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2010, 06:50 PM
  5. Screen updating
    By StevenS in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-15-2005, 12:05 PM

Tags for this Thread

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