Screen Updating on Open Workbook
I have written a macro to open 19 workbooks, copy a few rows of info, and
then write the copied rows to a consolidaton workbook. Everything is working
fine except I get the screen updated every time a new workbook opens even
though I have explicitly included Application.ScreenUpdate = False.
Does any one have any ideas about how to stop the screen from showing the
opening and closing of each workbook?
Thanks a lot.
|