Unwanted freezed screen cause by screenupdate = false
Hat happens when you run the macro, not debug? What line
is highlighted yellow? maybe you are not using
the "application".ScreenUpdating = False
Just a thought
Mark
-----Original Message-----
Hi! I experience when I go out from debugging mode, that
the screenupdate =
false still is active. I have error handlers to restore
screenupdate = true,
but often they don't seem to work.
Could it be that when an error occure and you get the
question if you want
to debugg, the error handler doesn't become active if you
doesn't take the
code by hand through the handler??
Please feel free to answer any of the questions!
Q1: Can you ensure the screenupdate = true or even
better the error
handler always to be executed, when leaving debugg mode?
Q2: Can you stop the question about debbugging or not? I
have error handler
for that.
Q3: How long will the screen update continue? If I choose
window to Word or
Internet Explorer? MS IE seem to be affected
sometimes...I thought all
settings went to normal when you leave excel? - Or do you
have to terminate
Excel?
.
|