Results 1 to 6 of 6

Screen Updating starts before asked to do so in procedure

Threaded View

  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:

    Private Sub Workbook_Open()
    
    Application.Run "Show_FileLoadMessage"  'Select the Sheet with Message
    
    Application.ScreenUpdating = False
    
    'Run Multiple Macros  (fyi: None of which "De-selects or selects another sheet")
    
    Application.ScreenUpdating = True
    
    Application.Run "Hide_FileLoadMessage"  'Hide Sheet with Message
    
    Sheets("Main Menu").Select
    
    end sub
    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.

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. [SOLVED] 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