How to stop screen blinking when running macro

[Stephen]

Hi

I have prepared a macro that needs to access 2 different workbooks. However, when I run the macro, the screen blinkx until the macro finished running. Is there any way I can stop the screen blinking

Thanks in advance

-- Stephen

 

[Guest]

Try screenupdating = False / True, like:

Sub Test
Application.ScreenUpdating = False

Sheet2.Activate
Sheet2.Range ("A1").Select
Sheet1.Activate
Sheet1.Range ("A1").Select

Application.ScreenUpdating = True
End Sub

/Regards Nobody

Hi,

I have prepared a macro that needs to access 2 different workbooks.

However, when I run the macro, the screen blinkx until the macro finished
running. Is there any way I can stop the screen blinking?