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.

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
-----


--
Regards
Frank Kabel
Frankfurt, Germany

Michael wrote:
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,

I think you mean to say:

Application.ScreenUpdating = True

in your second Application.ScreenUpdating statement.

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

Shatin
thanks for this correction (copy+paste error)


--
Regards
Frank Kabel
Frankfurt, Germany

Shatin wrote:
Frank,

I think you mean to say:

Application.ScreenUpdating = True

in your second Application.ScreenUpdating statement.

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

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.. :-