Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
make a splash screen appear first | Charts and Charting in Excel | |||
How Do I Autofit To Screen Size | Excel Worksheet Functions | |||
Need to convert point on screen to various screen resolutions | Excel Discussion (Misc queries) | |||
Hyperlink Screen Tips not cross platform | Excel Discussion (Misc queries) | |||
How do I move the current cell to the top of the screen? | Excel Discussion (Misc queries) |