Prev: Copy varaible no. of rows to another woorkbook
Next: using VLOOKUP in a text box
From: Spike on 5 May 2010 11:41
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
From: Paul Robinson on 5 May 2010 14:32
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 <Sp...(a)discussions.microsoft.com> 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

From: Spike on 6 May 2010 01:55
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 <Sp...(a)discussions.microsoft.com> 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
>
> .
>
 | 
Pages: 1
Prev: Copy varaible no. of rows to another woorkbook
Next: using VLOOKUP in a text box