If you let the workbook open, can you rearrange that window:

Window|Arrange|tiled

Then resize the way you want it and save that workbook.

It kind of sounds like the window to the worksheet is just off the visible
screen.

KentKHI wrote:
>
> Hi Everyone!
>
> I randomly have a problem with some of my worksheets, and lately a lot more
> often. When I open them, even before I select yes, run macros, about a
> quarter of the right side of the workbook fully grays out. It grays out the
> column headings, and all of the way down to even gray out the sheet tabs. It
> also starts clear at the edge of the screen.
>
> The only way that I can get around this is to open a blank excel document
> first, and then open my working or "important" document.
>
> Has anyone ever heard of this?
> --
> Thanks for the help (I need all I can get!)

--

Dave Peterson