part of the screen becomes greyed out

[methody]

Hello
I have a fairly large excel file with lots of worksheets, formulas, macros and worksheet change events. Sometimes when a macro runs a rectangular area the full length of the screen and about 2 inches wide covers the left hand side of the screen and you cnt get rid of it without closing excel dowm altogether and restarting.

Does anybody recognise the problem or have any idea as to what may be causing it?

 

[HalfAce]

Hello methody,
Is it just one (or more) specific macro(s) that cause this to happen?
(Are these all macros that you yourself have written/recorded? - or are you otherwise
familiar with the code?)

The only thing that comes to mind right off is that maybe the code is setting the
scroll area.