Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I stop Excel program flashing on screen during run
I have some code that processes files in a directory and
extracts one piece of data. During the process a the following is executed: Workbooks.OpenText Filename:= _ strDirName & strItem, Origin:=xlMSDOS, StartRow:=2, DataType:=xlFixedWidth, FieldInfo:= _ Array(Array(0, 1), Array(146, 1), Array(156, 1)), TrailingMinusNumbers:=True While this is running - it flashes on the screen. Is there any way of stopping this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I stop Excel program flashing on screen during run
hi,
use application.screenupdating = false at the beginning of your code. arno |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I stop Excel program flashing on screen during run
This will work for the main Excel window
Put this at the beginning of your code: Application.ScreenUpdating = False and this at the end: Application.ScreenUpdating = Tru -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I stop Excel program flashing on screen during run
Thanks. That has worked a treat.
PJ -----Original Message----- hi, use application.screenupdating = false at the beginning of your code. arno . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen flashing | Excel Discussion (Misc queries) | |||
How to stop the screen from 'flashing' when copying and pasting | Excel Discussion (Misc queries) | |||
Screen flashing why? | Excel Discussion (Misc queries) | |||
Eliminate screen flashing while running a macro using VBA in Microsoft Excel. | Excel Programming | |||
Screen is flashing when VBA adding objects into Excel sheet? | Excel Programming |