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
|