application screenupdating issue

  • Thread starter Thread starter Gary Keramidas
  • Start date Start date
G

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?
 
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,
You are welcome, appreciate the update.
Jim Cone


"Gary Keramidas" <GKeramidasATmsn.com> wrote in message
works fine jim. thanks again
Gary
 
Back
Top