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