Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to stop screen blinking when running macro
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to stop screen blinking when running macro
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" skrev i meddelandet ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide screen movements when a macro is running | Excel Discussion (Misc queries) | |||
Blinking/flickering screen | Excel Discussion (Misc queries) | |||
How do I stop a Macro from running? | Excel Worksheet Functions | |||
When Save As stop running macro | Excel Programming | |||
How to Pause or Stop a running Macro | Excel Programming |