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

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

i'll move all the code in all the workbooks after my client closes tonight and
give it a shot.

thanks

--


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

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

Gary,
You are welcome, appreciate the update.
Jim Cone


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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