Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unwanted freezed screen cause by screenupdate = false
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unwanted freezed screen cause by screenupdate = false
Can't answer all your questions, but you might check
VBAToolsOptionsGeneral to make sure that Error Trapping is set to Break on Unhandled Errors. If it is not, that could be the answer to questions one and two, assuming that your error handling is done correctly. -----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? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thanks, that was the solution...
Hi and thank you. It was the Break on Unhandled Errors that was missing...
/Regards "Ken" skrev i meddelandet ... Can't answer all your questions, but you might check VBAToolsOptionsGeneral to make sure that Error Trapping is set to Break on Unhandled Errors. If it is not, that could be the answer to questions one and two, assuming that your error handling is done correctly. -----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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested if with an unwanted false result | Excel Discussion (Misc queries) | |||
print freezed pane | Excel Discussion (Misc queries) | |||
Auto time freezed | Excel Worksheet Functions | |||
Unwanted replicated split screen | Excel Discussion (Misc queries) | |||
DisplayAlerts and ScreenUpdate will not set to False | New Users to Excel |