ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Screen flashing why? (https://www.excelbanter.com/excel-discussion-misc-queries/88880-screen-flashing-why.html)

Chet

Screen flashing why?
 
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

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


All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com