application screenupdating issue

[Gary Keramidas]

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

[Jim Cone]

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 Keramidas]

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

thanks

--


Gary


"Jim Cone" <[email protected]> wrote in message
news:[email protected]...
> 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 Keramidas]

works fine jim. thanks again

--


Gary


"Jim Cone" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>

[Jim Cone]

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


"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
news:[email protected]...
works fine jim. thanks again
Gary


"Jim Cone" <[email protected]> wrote in message
news:[email protected]...
> 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