How to hide all the executing screens of the macro's that are running

0

Hello,

can anyone tell me how to hide all the flickering screens while a couple of macro's is running? Ik think it is something about "Dim" but I don't know the exact formule.

Answer
Discuss

Answers

0
Application.ScreenUpdating = False

should be entered into the code before any code commands that write to a worksheet and reversed with Application.ScreenUpdating = True when the writing is done. This will not only stop most of the flickering but also speed up execution of the code because updating the picture all the time eats up resources, too.

However, excessive flickering may also be caused by the use of Select and Activate statements in the code. Code like

Worksheets("Sheet1").Activate
ActiveSheet.Cells(1, 1).Select
Selection.Value = "Here's Range(A1)"

will cause a lot of flicker and redundancy, too. It's like saying,

"Jack, come here"
"The person who is here listen to me"
"The person who is listening to me to hand me the towel".

This can be done to same effect with

"Jack, hand me the towel"
or
Worksheets("Sheet1").Cells(1, 1).Value = "Here's Range(A1)"

Without flicker.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login