#1   Report Post  
KentKHI
 
Posts: n/a
Default Grayed out worksheet

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!)
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to search for and display data in another worksheet Mark H Excel Worksheet Functions 0 June 14th 05 12:40 PM
Search/Match between 2 x separate Worksheets and populate result in third worksheet Alan Bartley Excel Discussion (Misc queries) 1 April 11th 05 05:21 AM
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
Indirect reference from one worksheet to another Bill Sturdevant Excel Worksheet Functions 2 December 17th 04 01:23 PM
Grayed Out Worksheet Tabs Joe Castellucci Excel Worksheet Functions 2 October 30th 04 04:24 PM


All times are GMT +1. The time now is 04:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"