How to keep from going dizzy when my code runs

  • Thread starter Thread starter TBA
  • Start date Start date
T

TBA

I know I've seen this tip on this group before, but for the life of me I
can't even begin to think on how to do a Google search for it.

How do I keep my Workbook and Worksheets from flashing and changing as my
code runs? My code is working, but it's terrible on the eyes, makes me kind
of dizzy. I know there's a simple statement that takes care of this, just
can't remember what it is for the life of me.

Anybody?

Thanks!

-gk
 
Application.ScreenUpdating = False
' your code
Application.ScreenUpdating = True

Regards

Trevor
 
TBA,

Precede it by

Application.DisplayAlerts = False

reset it afterwards if there is more code, and not the end of the sub.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Oops,

I mean Application.ScreenUpdating = False not DisplayAlerts as I said. Reset
at end.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top