Thread: Screen Flicker
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dim dim is offline
external usenet poster
 
Posts: 123
Default Screen Flicker

Hi folks,

When I run a macro I've disabled some screen flicker using
ScreenUpdating=False which works fine. But part of my macro is to open then
close another workbook, and when it opens it automatically displays for a
second until it closes again. Is there any way I can stop this?

Maybe there's some sort of option in Excel that doesn't open new workbooks
as the front window and I could include the selection of this option as part
of my macro.....

Any ideas are much appreciated?
Thanks