Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce Flashing
Excel 2002. My workbook has about 30 worksheets which I activate
sequentially to simulate animation. Problem is, Excel seems to want to clear each worksheet in turn as it is activated and then re-display all the drawing objects on it. This causes a distracting flashing as the worksheets are activated. Is there a workaround for this? TIA, James |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce Flashing
Try:
Application.ScreenUpdating = False ' your code Application.ScreenUpdating = True Regards Trevor "Zone" wrote in message oups.com... Excel 2002. My workbook has about 30 worksheets which I activate sequentially to simulate animation. Problem is, Excel seems to want to clear each worksheet in turn as it is activated and then re-display all the drawing objects on it. This causes a distracting flashing as the worksheets are activated. Is there a workaround for this? TIA, James |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce Flashing
Thank you, Trevor, but application.screenupdating=False prevents the
display of the various sheets. Evidently, if I put this instruction in before the next sheet is activated, the screen fails to show the next sheet. If I put it after the next sheet is activated, it's too late to prevent the sheet from updating itself. James Trevor Shuttleworth wrote: Try: Application.ScreenUpdating = False ' your code Application.ScreenUpdating = True Regards Trevor "Zone" wrote in message oups.com... Excel 2002. My workbook has about 30 worksheets which I activate sequentially to simulate animation. Problem is, Excel seems to want to clear each worksheet in turn as it is activated and then re-display all the drawing objects on it. This causes a distracting flashing as the worksheets are activated. Is there a workaround for this? TIA, James |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce Flashing
As your need to show each step of the "animation", that is what you are
seeing. If there are blocks of code that you do not need the user see, then sandwich them in .DisplayAlerts=false/True statements. Not sure, but playing with Application.Calculation and possibly Worksheet.DisplayPageBreaks, may help. NickHK "Zone" egroups.com... Excel 2002. My workbook has about 30 worksheets which I activate sequentially to simulate animation. Problem is, Excel seems to want to clear each worksheet in turn as it is activated and then re-display all the drawing objects on it. This causes a distracting flashing as the worksheets are activated. Is there a workaround for this? TIA, James |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce Flashing
Another thing to try is putting
Application.Screenupdating = True Application.Screenupdating = False .... pairs of code-lines at the places in your process that you want to see what has been updated. It has the effect of redrawing the screen and then freezing it again. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reduce Flashing
Yes, that I meant, not .DisplayAlerts.
Don't know where taht came from. NickHK "Greg Glynn" egroups.com... Another thing to try is putting Application.Screenupdating = True Application.Screenupdating = False ... pairs of code-lines at the places in your process that you want to see what has been updated. It has the effect of redrawing the screen and then freezing it again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flashing value | Excel Discussion (Misc queries) | |||
Flashing Cell | Excel Discussion (Misc queries) | |||
Flashing cells | Excel Worksheet Functions | |||
flashing cell | Excel Discussion (Misc queries) | |||
Flashing spreadsheet | Excel Discussion (Misc queries) |