Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am getting a bit frustrated. I found this question in several places, but
no answers. Please help! The command: "application.screenupdating = false" no longer works. I restarted my computer and restarted Excel. I opened a new workbook, and typed in a test macro. sub test() application.screenupdating = false .... No matter what I do, I can no longer get screen updating to stop. I was running a macro that opens a *.wk3 file, copies info into a *.xls file, and continues with the next .wk3 file. When I am done, I have a neat list of information in Excel compiled from 3,500 .wk3 files. To speed things, I used at the beginning of my code: application.screenupdating = false It worked beautifully for a while. However, some .wk3 files contained an error in a specific cell and would stop until I responded to the alert. To avoid the annoying alert, I used this: on error resume next application. displayalerts = false Maybe this caused a problem? Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
application screenupdating issue | Excel Programming | |||
PLEASE PLEASE HELP Application.Screenupdating | Excel Programming | |||
Application.ScreenUpdating MsgBox | Excel Programming | |||
Application.ScreenUpdating problem | Excel Programming | |||
Question on application.screenupdating | Excel Programming |