![]() |
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 |
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