View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default application screenupdating issue

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