ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Left Side of Excel Screen Turns Gray (https://www.excelbanter.com/excel-programming/296343-left-side-excel-screen-turns-gray.html)

[email protected]

Left Side of Excel Screen Turns Gray
 
Hell-o,

On occasion, I will run VBA code and, of some reason, the
left side (columns A to D) will gray out with the right
side appearing normal. The code will continue and
properly finish however, the left side will remain gray.
To remove the gray, I have to close the worksheet, exit
Excel and re-open the spreadsheet. Any ideas what might
be the root of this problem?

PS I often use Application.ScreenUpdating command.

bwilcox

Tom Ogilvy

Left Side of Excel Screen Turns Gray
 
Are you making the outline section visible, or are columns A to D really
turning Gray?

--
Regards,
Tom Ogilvy

" wrote in message
...
Hell-o,

On occasion, I will run VBA code and, of some reason, the
left side (columns A to D) will gray out with the right
side appearing normal. The code will continue and
properly finish however, the left side will remain gray.
To remove the gray, I have to close the worksheet, exit
Excel and re-open the spreadsheet. Any ideas what might
be the root of this problem?

PS I often use Application.ScreenUpdating command.

bwilcox




No Name

Left Side of Excel Screen Turns Gray
 
Columns A to D are truning gray.


-----Original Message-----
Are you making the outline section visible, or are

columns A to D really
turning Gray?

--
Regards,
Tom Ogilvy

"

wrote in message
...
Hell-o,

On occasion, I will run VBA code and, of some reason,

the
left side (columns A to D) will gray out with the right
side appearing normal. The code will continue and
properly finish however, the left side will remain gray.
To remove the gray, I have to close the worksheet, exit
Excel and re-open the spreadsheet. Any ideas what might
be the root of this problem?

PS I often use Application.ScreenUpdating command.

bwilcox



.



All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com