Flickering screen while processing macro
Try
Application.screenupdating = false
your code
Application.screenupdating=true
Mike
"Pa Maher" wrote:
Based on input from the User, a macro takes data from several worksheets and
inputs the data to a form which then is further updated by the user. The
screen flickers as the program copies and pastes data.
Is there some way to mask the flicker by using a "splash screen" (if I am
using the term properly), which would disappear when the update is completed?
The displayed message would read:
"Please wait while CAIS is being created" and also include a creation
graphic that I have.
Thanks in advance!
|