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

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.