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" wrote in message
...
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

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)

"TBA" wrote in message
...
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

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)

"Bob Phillips" wrote in message
...
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)

"TBA" wrote in message
...
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