How to stop screen blinking when running macro

S

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
 
G

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

Stephen said:
Hi,

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