??? application.screenupdating no longer works! Why???
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.
|