View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CraTaw CraTaw is offline
external usenet poster
 
Posts: 3
Default ??? 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.