Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
link updating on workbook open | Links and Linking in Excel | |||
How do I open several worksheets from the same workbook on screen | Excel Worksheet Functions | |||
Screen Updating | Excel Programming | |||
Screen Updating | Excel Worksheet Functions | |||
Screen updating | Excel Programming |