Real Challenge: supress the flicking when prog is running

[Miguel Castanuela]

Somebody knows how to suppress the constant "flick" when a program is running? This is, to avoid that the user sees all the actions (the creation of graphics, scroll of lines, etc.) as long they are executed, in excel for example (execution in background))?

Thanks in advance

 

[Eric Lawrence [MSFT]]

Can you hide the background Office application until the document is
created? It'll run faster too.

--
Thanks,

Eric Lawrence
Program Manager
Assistance and Worldwide Services

This posting is provided "AS IS" with no warranties, and confers no rights.

Somebody knows how to suppress the constant "flick" when a program is

running? This is, to avoid that the user sees all the actions (the creation
of graphics, scroll of lines, etc.) as long they are executed, in excel for
example (execution in background))?

 

[Eric Lawrence [MSFT]]

A colleague who's far more familiar with such things notes that you can use
Application.ScreenUpdating = False to turn off redraw\flickering due to
screen updating.

--
Thanks,

Eric Lawrence
Program Manager
Assistance and Worldwide Services

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Miguel Castanuela]

It works! many thanks, this is right what I needed
Great tip BTW