Controlling Screen flashing using LockWindowUpdate

Hi,

A while back I was assisted with trying to prevent excessive screen flashing...

I was originally using the Application.ScreenUpdating=False method...but it was still a little jumpy... so Richard Schollar (a valued member in our forum) helped me with this code and it seemed to work...

Now I am trying to apply it again to another macro and it is not working so well. The thing I found is that on some people's computers it does work well, but not on mine.

Does anyone know why that is and how I can fix it so it doesn't flash on mine either?

Private Declare Function LockWindowUpdate Lib "user32" _
  (ByVal hwndLock As Long) As Long

Sub RunProjectUpdate()

LockWindowUpdate Application.Hwnd


.....

'You MUST turn it back on at the end!!!:

LockWindowUpdate ByVal 0&   'simply passing a long value of 0 into the function

End Sub

Thanks for any advice.