works fine jim. thanks again

--


Gary


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