View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Screen flashing why?

Maybe your event code is causing other events (or the same event) to fire over
and over and over -- until excel gets tired.

You may want to add:

application.enableevents = false
'your code that does something that causes another event to fire
application.enableevents = true


===

This may hide the flickering, but doesn't really fix the problem:
application.screenupdating = false
'your code
application.screenupdating = true



Chet wrote:

I have a few "drawing boxes" added to a workbook and now the screen
flashes for about 20-30 seconds before settling down. I do have some
macros in the macro modules but they are not being run at all while the
screen is flashing. The flashing seems to stop after 20-30 seconds or
so.

Thanks,
Chet


--

Dave Peterson