Screenupdate = False not working

  • Thread starter Thread starter Cade
  • Start date Start date
C

Cade

Hi,

I'm experiencing in some code I wrote that the statement

Appliation.Screenupdate = False

doesn't seem to work. Despite the line of code, the screen still
changes when I select or activate another worksheet in the workbook in
my code.

Any ideas? I'm still on Excel 97, not by choice =)

Cade
 
Hey Paul,

sorry, thats what I actually had in the code. It's definitely not working though.

Cade
 
Does "not working" mean that it works for awhile, then gets turned on?

If yes, then you'll have to find the piece of code that's turning it back on and
add another one to turn it off. (There are a few things that turn this on
without your permission.)

If you sprinkle a few:
debug.print "step xx: " & application.screenupdating
You might be able to find the step that turns it on.

(and you may want to check to see if you have "screenupdating = true" in code
that you forgot about. (much more likely in my code!)
 
Back
Top