Screen flashing why?

C

Chet

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
 
D

Dave Peterson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top