Hi Gary,
In the dependent workbooks, try putting your ScreenUpdating code in an
Auto_Open sub in a general module. An auto_open sub is not called
if the workbook is opened by code, but runs if the workbook is opened normally.
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
i have an issue with turning off screenupdating. i open a series of workbooks to
create reports in a master. the workbooks have workbook_open code that turns
screenupdating off and then back on. so when my code is running in the master,
screenupdating gets turned back on after i open each workbook.

i added another screenupdating = false line right after the code that opens the
workbook and the screen doesn't flash, but i still see each workbook i'm opening
while i'm copying the data from it.
anyway around this?
Gary