That DURN Screen Flicker !!!

[Logit]

.
These lines of code have always proved successful.

Now, for some reason, it isn't doing it's job. Is there any other way of stopping screen flicker ?

With Application
        .ScreenUpdating = False
        .DisplayStatusBar = False
        .Calculation = xlCalculationManual
        .EnableEvents = False
End With

With Application
        .ScreenUpdating = True
        .DisplayStatusBar = True
        .Calculation = xlCalculationAutomatic
        .EnableEvents = True
End With

- OR -

Application.ScreenUpdating = False
Application.ScreenUpdating = True

[jolivanes]

Any of the suggestions in here help?
http://www.vbforums.com/showthread.p...-does-not-work

[Logit]

.
Thank you sir for the URL link !

The contents of those posts from different individuals was very enlightening. I had no idea (have never heard anyone say) that
there were so many different methods of stopping the flicker and it all depends on the individual workbook. Another Microsoft
free amenity ?

I have solved the flicker by experimenting with the location of inserting : Application.ScreenUpdating = False

First I removed the two lines : Application.ScreenUpdating = False & Application.ScreenUpdating = True from all the locations I felt were contributing
to the problem.

Then I inserted only the line : Application.ScreenUpdating = False at various locations at the top of the macro code. Only a few instances of this helped.


What completely rid my project of the flicker was to place that line ( Application.ScreenUpdating = False ) at the top of each macro the runs when the user
clicks on a command button. It was primarily the buttons that were giving the worse flicker response. The flicker completely stopped after inserting
the code line.

Now ... what is truly unusual is that none of the other macros throughout the workbook have anything to do with the command buttons. The only way the macro
within the button is activated is by clicking the button. SO GO FIGURE ! ????

Again .. thank you for the resource !

[jolivanes]

The importance is that it is solved.
Thank you for the explanation which will help people in the future.
Good luck