Screen Flicker while processing

[Michael]

Ok I know this one is probably simple.

How can I make the screen show something other than all the flicker as a
macro executes. I would like to do something like a logo or Please Wait.
But a blank would be fine.

I would like to add it to the begining of my code and turn it off at the
end.

 

[Frank Kabel]

Hi Michael
you may wrap your code in the following statements to prevent the
flickering

-----
Sub foo()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
'...
'enter your code
'...
Application.ScreenUpdating = False
Application.Calculation = xlCalculationAutomatic
end sub

 

[Shatin]

Frank,

I think you mean to say:

Application.ScreenUpdating = True

in your second Application.ScreenUpdating statement.

 

[Frank Kabel]

Shatin
thanks for this correction (copy+paste error)

 

[altira]

On 2004-February-Thursday - 05:31:14 was cache-ntc-ab05.proxy.aol.co
( Mozilla/4.0 (compatible; MSIE 6.0; AOL 9.0; Windows NT 5.1; .NE
CLR 1.1.4322) ) with the following IP 198.81.26.42 on your boar

Application.ScreenUpdating = Fals

Turns screen off "True" turns it on... No more flickers.. :-