Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Redraw Application Window
How Do I cause the Excel Application Window to re-draw on
screen. I have a form in one workbook that is open. I want to close the current workbook and open another (which is working) but when the macro I am using runs the form from the previous workbook is still visible. For whatever reason the screen does not redraw. The workbook closes as expected, but the screen does not refresh and the form from the first workbook is still visible even though its workbook has closed. I know it is a matter of just causing the screen to refresh, but I am not sure how to make that happen. Thanks in advance. Kevin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Redraw Application Window
I sounds like you have turned screen updating to off, so turn it back on,
then off again if that is what you want Application.ScreenUpdating = True Application.ScreenUpdating = False or if it is on and this really is a problem then put in lines like (turn it off, then back on to stimulate the screen update - throw in a couple of doevents as well). DoEvents Application.ScreenUpdating = False Application.ScreenUpdating = True DoEvents -- Regards, Tom Ogilvy "Kevin" wrote in message ... How Do I cause the Excel Application Window to re-draw on screen. I have a form in one workbook that is open. I want to close the current workbook and open another (which is working) but when the macro I am using runs the form from the previous workbook is still visible. For whatever reason the screen does not redraw. The workbook closes as expected, but the screen does not refresh and the form from the first workbook is still visible even though its workbook has closed. I know it is a matter of just causing the screen to refresh, but I am not sure how to make that happen. Thanks in advance. Kevin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Redraw Application Window
Thanks Tom! That fixed it!
-----Original Message----- How Do I cause the Excel Application Window to re-draw on screen. I have a form in one workbook that is open. I want to close the current workbook and open another (which is working) but when the macro I am using runs the form from the previous workbook is still visible. For whatever reason the screen does not redraw. The workbook closes as expected, but the screen does not refresh and the form from the first workbook is still visible even though its workbook has closed. I know it is a matter of just causing the screen to refresh, but I am not sure how to make that happen. Thanks in advance. Kevin . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Determine if Application Window Still Active | Excel Discussion (Misc queries) | |||
How do I open a new window for each excel application? | New Users to Excel | |||
How to set Excel to open a new window for each application | Excel Discussion (Misc queries) | |||
How do I set up Excel to open a new instance/application window w. | Excel Discussion (Misc queries) | |||
Locking the Application Window size | Excel Programming |