software

I have a few quot;drawing boxesquot; 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,
ChetMaybe 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:
gt;
gt; I have a few quot;drawing boxesquot; added to a workbook and now the screen
gt; flashes for about 20-30 seconds before settling down. I do have some
gt; macros in the macro modules but they are not being run at all while the
gt; screen is flashing. The flashing seems to stop after 20-30 seconds or
gt; so.
gt;
gt; Thanks,
gt; Chet

--

Dave Peterson