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.

Hi Paul,

There must be something in your code which explicitly, ot implicitly, resets
the screenupdating setting. However, without seeing your code it is
difficult to speculate.

Certainly, code such as the following works for me without the refressh
problems that you encounter:

'=============
Public Sub TesterAAA()
Application.ScreenUpdating = False
Dim i As Long

For i = 1 To 3
Workbooks.Open Filename:="Tester" & i & ".xls"
Call MyMessage
Next i
Application.ScreenUpdating = True

End Sub

'-----------

Public Sub MyMessage()
MsgBox "Ciao!"
End Sub
'<<=============


---
Regards,
Norman



"PaulZ" wrote in message
...
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.