NEED a PRO: Screen Epilepsy
 

I found a number of posts relating to this, but ain't yet seen nothin'
of any consequence, so..

Even though I clamped down on the modules / sheet changes with
Application.ScreenUpdate = False

and further made certain I was not turning it on and turning it off
when multiple modules were called and I was resetting protection on and
off for sheet info being written, and took the exact same precaution for

Application.EnableEvents = False

, the sheet the code initiates from, and especially the shapes thereon,
flash like the screen is having a freaking seizure.

One of you old pros or young geniuses out there (I am an old
hunt-and-pecker, but my wife just calls me "pecker" for short): What
the heck else can I do to try to eliminate all that flicker???
(Please!!!)


--
brucemc
------------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...o&userid=32871
View this thread: http://www.excelforum.com/showthread...hreadid=556720

NEED a PRO: Screen Epilepsy
 

The only setting which affects scree flicker is screen updating. The most
likely cause of the flick is (ironically enough) overuse of the screen
updating. Every time screen updating is turned on (application.screenupdating
= true) the screen will refresh itself. So if I have two procedures one
calling the other in a loop such as this...

sub mainprocedure
dim i as integer
application.screenupdating = false
for i = 1 to 100
call MySub
sheets("Sheet1").select
next i
application.screenupdating = true 'flicker
end sub

sub MySub()
application.screenupdating = false
sheets("Sheet2").select
application.screenupdating = true 'flicker
end sub

Then my screen will update 101 times and flicker...
--
HTH...

Jim Thomlinson


"brucemc" wrote:


I found a number of posts relating to this, but ain't yet seen nothin'
of any consequence, so..

Even though I clamped down on the modules / sheet changes with
Application.ScreenUpdate = False

and further made certain I was not turning it on and turning it off
when multiple modules were called and I was resetting protection on and
off for sheet info being written, and took the exact same precaution for

Application.EnableEvents = False

, the sheet the code initiates from, and especially the shapes thereon,
flash like the screen is having a freaking seizure.

One of you old pros or young geniuses out there (I am an old
hunt-and-pecker, but my wife just calls me "pecker" for short): What
the heck else can I do to try to eliminate all that flicker???
(Please!!!)


--
brucemc
------------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...o&userid=32871
View this thread: http://www.excelforum.com/showthread...hreadid=556720

NEED a PRO: Screen Epilepsy
 

Just to cover all of the bases, depending on what errorhandling he is using

Application.ScreenUpdate = False

would not disable screenupdating. Maybe a typo in the OP's part?


"Jim Thomlinson" wrote:

The only setting which affects scree flicker is screen updating. The most
likely cause of the flick is (ironically enough) overuse of the screen
updating. Every time screen updating is turned on (application.screenupdating
= true) the screen will refresh itself. So if I have two procedures one
calling the other in a loop such as this...

sub mainprocedure
dim i as integer
application.screenupdating = false
for i = 1 to 100
call MySub
sheets("Sheet1").select
next i
application.screenupdating = true 'flicker
end sub

sub MySub()
application.screenupdating = false
sheets("Sheet2").select
application.screenupdating = true 'flicker
end sub

Then my screen will update 101 times and flicker...
--
HTH...

Jim Thomlinson


"brucemc" wrote:


I found a number of posts relating to this, but ain't yet seen nothin'
of any consequence, so..

Even though I clamped down on the modules / sheet changes with
Application.ScreenUpdate = False

and further made certain I was not turning it on and turning it off
when multiple modules were called and I was resetting protection on and
off for sheet info being written, and took the exact same precaution for

Application.EnableEvents = False

, the sheet the code initiates from, and especially the shapes thereon,
flash like the screen is having a freaking seizure.

One of you old pros or young geniuses out there (I am an old
hunt-and-pecker, but my wife just calls me "pecker" for short): What
the heck else can I do to try to eliminate all that flicker???
(Please!!!)


--
brucemc
------------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...o&userid=32871
View this thread: http://www.excelforum.com/showthread...hreadid=556720

NEED a PRO: Screen Epilepsy
 

typo: yup. s/b with ing, tried typing too fast

--
brucem
-----------------------------------------------------------------------
brucemc's Profile: http://www.excelforum.com/member.php...fo&userid=3287
View this thread: http://www.excelforum.com/showthread.php?threadid=55672