Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen repainting issue
I have a workbook that now and again after running a macro (issue occurs with
many different macros) the first say five or six columns are covered in grey so one cannot read the data below the grey. If you scroll to the right then all those columns up to the end (IV) are visible as usual. If you change sheets then the grey panel is showing on each sheet. Any ideas to prevent this occurring will be very gratefully received -- with kind regards Spike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen repainting issue
Hi
Hard to be too specific without seeing any code. Suggestions 1. Put in Application.screenupdating = false at the top of each macro so save the screen having to update itself till the macro has finished. 2. Put in DoEvents after every section of code that is having to update the screen. Might fix it, especially if you are using Excel 2007 where the screen graphics can be horribly slow.... regards Paul On May 5, 4:41*pm, Spike wrote: I have a workbook that now and again after running a macro (issue occurs with many different macros) the first say five or six columns are covered in grey so one cannot read the data below the grey. *If you scroll to the right then all those columns up to the end (IV) are visible as usual. *If you change sheets then the grey panel is showing on each sheet. Any ideas to prevent this occurring will be very gratefully received -- with kind regards Spike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen repainting issue
thanks, i will try the DoEvents, i already have screenupdatng etc.
It is something i have never seen before and hope i do not again as a pain -- with kind regards Spike "Paul Robinson" wrote: Hi Hard to be too specific without seeing any code. Suggestions 1. Put in Application.screenupdating = false at the top of each macro so save the screen having to update itself till the macro has finished. 2. Put in DoEvents after every section of code that is having to update the screen. Might fix it, especially if you are using Excel 2007 where the screen graphics can be horribly slow.... regards Paul On May 5, 4:41 pm, Spike wrote: I have a workbook that now and again after running a macro (issue occurs with many different macros) the first say five or six columns are covered in grey so one cannot read the data below the grey. If you scroll to the right then all those columns up to the end (IV) are visible as usual. If you change sheets then the grey panel is showing on each sheet. Any ideas to prevent this occurring will be very gratefully received -- with kind regards Spike . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen wrapping issue | Excel Discussion (Misc queries) | |||
Grey screen issue - HELP | Excel Programming | |||
Form Repainting Problem | Excel Programming | |||
Repainting a Workbook | Excel Discussion (Misc queries) | |||
refreshing or repainting worksheet | Excel Programming |