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