+ Reply to Thread
Results 1 to 8 of 8

Application.screenupdating fail

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    07-01-2008
    Location
    Cincinnati, OH
    Posts
    150
    Sometimes this construct works where App.ScreenUpdating fails.

    Private Declare Function LockWindowUpdate Lib "user32" (ByVal hwndLock As Long) As Long
    Private Declare Function GetDesktopWindow Lib "user32" () As Long
    
    Sub SomeSub()
    
        On Error GoTo Err_SomeSub
        
        LockWindowUpdate GetDesktopWindow
        
        'your code
    
        LockWindowUpdate 0
        
    Exit Sub
    Err_SomeSub:
        LockWindowUpdate 0
        
    End Sub

  2. #2
    Forum Contributor
    Join Date
    06-15-2007
    Location
    Scotland
    Posts
    142
    thnaks for the suggestion, I did what you wrote, and works for one of the sub, however for another ones I still having the blinks,
    best regards

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525
    Quote Originally Posted by mmf View Post
    thnaks for the suggestion, I did what you wrote, and works for one of the sub, however for another ones I still having the blinks,
    best regards
    If you have selects in your code the blinks may be inevitable.
    Whats the code look like?

+ 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. Renaming Spreadsheet causes macros to fail
    By AdamParker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-11-2008, 11:45 AM
  2. List with missing links!!!
    By Sirishgreen in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-01-2007, 09:25 AM
  3. How can I fail based on an exception?
    By geezerman402 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2007, 06:25 PM
  4. Reviewing Toolbar - past results fail
    By The Muffin Man in forum Excel General
    Replies: 0
    Last Post: 04-25-2007, 11:46 AM
  5. calcule target value and % based on increased volume
    By diskette in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2007, 12:18 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1