ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Screen Issue - Bizarre!! (https://www.excelbanter.com/excel-programming/309913-excel-screen-issue-bizarre.html)

John Martin

Excel Screen Issue - Bizarre!!
 
On a variety of occasions while running VB code (different
code, different applications) the left side of the
worksheet area of the screen will become hidden by a gray
overlay of some kind.

The tool bar area and the status bar area are not
affected. The only way to clear up the problem is to close
excel and reopen it.

This occurs even if the code runs successfully.

Any suggestions are greatly appreciated.

Excel version = Excel 2002 with SP 2 installed.

Tom Ogilvy

Excel Screen Issue - Bizarre!!
 
It sounds like you are turning grouping and outlining on.

are there little buttons at the top and dot next to each row?

--
Regards,
Tom Ogilvy

"John Martin" wrote in message
...
On a variety of occasions while running VB code (different
code, different applications) the left side of the
worksheet area of the screen will become hidden by a gray
overlay of some kind.

The tool bar area and the status bar area are not
affected. The only way to clear up the problem is to close
excel and reopen it.

This occurs even if the code runs successfully.

Any suggestions are greatly appreciated.

Excel version = Excel 2002 with SP 2 installed.




John Martin

Excel Screen Issue - Bizarre!!
 
Tom, no little buttons, am not turning grouping or
outlining on. The area of the screen that becomes obscured
is a solid gray color about 2 inches wide by the height of
the worksheet area.

Thanks,

John


-----Original Message-----
It sounds like you are turning grouping and outlining on.

are there little buttons at the top and dot next to each

row?

--
Regards,
Tom Ogilvy

"John Martin" wrote

in message
...
On a variety of occasions while running VB code

(different
code, different applications) the left side of the
worksheet area of the screen will become hidden by a

gray
overlay of some kind.

The tool bar area and the status bar area are not
affected. The only way to clear up the problem is to

close
excel and reopen it.

This occurs even if the code runs successfully.

Any suggestions are greatly appreciated.

Excel version = Excel 2002 with SP 2 installed.



.


Tim[_39_]

Excel Screen Issue - Bizarre!!
 
I've had this happen too... if you right-click on it you get the short-cut
menu as if it was a toolbar area (i did anyway). whatever macros i was
running at the time (can't remember) would NOT have been related to either
toolbars or group/outlining (at least, not intentionally!).

it would be great if someone could shed some light.

cheers,

tim

"John Martin" wrote in message
...
Tom, no little buttons, am not turning grouping or
outlining on. The area of the screen that becomes obscured
is a solid gray color about 2 inches wide by the height of
the worksheet area.

Thanks,

John


-----Original Message-----
It sounds like you are turning grouping and outlining on.

are there little buttons at the top and dot next to each

row?

--
Regards,
Tom Ogilvy

"John Martin" wrote

in message
...
On a variety of occasions while running VB code

(different
code, different applications) the left side of the
worksheet area of the screen will become hidden by a

gray
overlay of some kind.

The tool bar area and the status bar area are not
affected. The only way to clear up the problem is to

close
excel and reopen it.

This occurs even if the code runs successfully.

Any suggestions are greatly appreciated.

Excel version = Excel 2002 with SP 2 installed.



.




Colin[_8_]

Excel Screen Issue - Bizarre!!
 
Tim,

I have a user that is having the same problem, and it is driving me
mad. This PC has a multi monitor setup and is using a Matrox card. I
have previously seen driver related issues like this, but nothing I've
tried so far has fixed this.

Are you guys using multi monitors or any funky graphics drivers?

Would love to get to the bottom of this.

Colin

"Tim" wrote in message ...
I've had this happen too... if you right-click on it you get the short-cut
menu as if it was a toolbar area (i did anyway). whatever macros i was
running at the time (can't remember) would NOT have been related to either
toolbars or group/outlining (at least, not intentionally!).

it would be great if someone could shed some light.

cheers,

tim

"John Martin" wrote in message
...
Tom, no little buttons, am not turning grouping or
outlining on. The area of the screen that becomes obscured
is a solid gray color about 2 inches wide by the height of
the worksheet area.

Thanks,

John


-----Original Message-----
It sounds like you are turning grouping and outlining on.

are there little buttons at the top and dot next to each

row?

--
Regards,
Tom Ogilvy

"John Martin" wrote

in message
...
On a variety of occasions while running VB code

(different
code, different applications) the left side of the
worksheet area of the screen will become hidden by a

gray
overlay of some kind.

The tool bar area and the status bar area are not
affected. The only way to clear up the problem is to

close
excel and reopen it.

This occurs even if the code runs successfully.

Any suggestions are greatly appreciated.

Excel version = Excel 2002 with SP 2 installed.


.


John Martin

Excel Screen Issue - Bizarre!!
 
I am not using a multimonitor -- just a dell laptop --
nothing special.

John
-----Original Message-----
Tim,

I have a user that is having the same problem, and it is

driving me
mad. This PC has a multi monitor setup and is using a

Matrox card. I
have previously seen driver related issues like this, but

nothing I've
tried so far has fixed this.

Are you guys using multi monitors or any funky graphics

drivers?

Would love to get to the bottom of this.

Colin

"Tim" <t_marsh@---take-this-out-to-reply---

atcentre.co.uk wrote in message
...
I've had this happen too... if you right-click on it

you get the short-cut
menu as if it was a toolbar area (i did anyway).

whatever macros i was
running at the time (can't remember) would NOT have

been related to either
toolbars or group/outlining (at least, not

intentionally!).

it would be great if someone could shed some light.

cheers,

tim

"John Martin"

wrote in message
...
Tom, no little buttons, am not turning grouping or
outlining on. The area of the screen that becomes

obscured
is a solid gray color about 2 inches wide by the

height of
the worksheet area.

Thanks,

John


-----Original Message-----
It sounds like you are turning grouping and

outlining on.

are there little buttons at the top and dot next to

each
row?

--
Regards,
Tom Ogilvy

"John Martin"

wrote
in message
...
On a variety of occasions while running VB code

(different
code, different applications) the left side of the
worksheet area of the screen will become hidden by

a
gray
overlay of some kind.

The tool bar area and the status bar area are not
affected. The only way to clear up the problem is

to
close
excel and reopen it.

This occurs even if the code runs successfully.

Any suggestions are greatly appreciated.

Excel version = Excel 2002 with SP 2 installed.


.

.


Chip Pearson

Excel Screen Issue - Bizarre!!
 
I use 3 19" LCD monitors hooked up to a Matrox 256 MB Parahelia
dual head video card, and I have no problems running Excel and/or
VBA. Word, on the other hand, does have problem with
multi-monitors.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Colin" wrote in message
om...
Tim,

I have a user that is having the same problem, and it is
driving me
mad. This PC has a multi monitor setup and is using a Matrox
card. I
have previously seen driver related issues like this, but
nothing I've
tried so far has fixed this.

Are you guys using multi monitors or any funky graphics
drivers?

Would love to get to the bottom of this.

Colin

"Tim"
wrote in message ...
I've had this happen too... if you right-click on it you get
the short-cut
menu as if it was a toolbar area (i did anyway). whatever
macros i was
running at the time (can't remember) would NOT have been
related to either
toolbars or group/outlining (at least, not intentionally!).

it would be great if someone could shed some light.

cheers,

tim

"John Martin" wrote in
message
...
Tom, no little buttons, am not turning grouping or
outlining on. The area of the screen that becomes obscured
is a solid gray color about 2 inches wide by the height of
the worksheet area.

Thanks,

John


-----Original Message-----
It sounds like you are turning grouping and outlining on.

are there little buttons at the top and dot next to each

row?

--
Regards,
Tom Ogilvy

"John Martin" wrote

in message
...
On a variety of occasions while running VB code

(different
code, different applications) the left side of the
worksheet area of the screen will become hidden by a

gray
overlay of some kind.

The tool bar area and the status bar area are not
affected. The only way to clear up the problem is to

close
excel and reopen it.

This occurs even if the code runs successfully.

Any suggestions are greatly appreciated.

Excel version = Excel 2002 with SP 2 installed.


.




Tim[_39_]

Excel Screen Issue - Bizarre!!
 
It's a work laptop, but from what i can see its a TridentVideo Accelerator
Cyberblade XPAi1 v6.4022-016B.221CDNP

it was set to muiltiple monitors until about one minute ago! i've just
changed it to the single internal monitor setting.

does that help?!

"Chip Pearson" wrote in message
...
I use 3 19" LCD monitors hooked up to a Matrox 256 MB Parahelia
dual head video card, and I have no problems running Excel and/or
VBA. Word, on the other hand, does have problem with
multi-monitors.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Colin" wrote in message
om...
Tim,

I have a user that is having the same problem, and it is
driving me
mad. This PC has a multi monitor setup and is using a Matrox
card. I
have previously seen driver related issues like this, but
nothing I've
tried so far has fixed this.

Are you guys using multi monitors or any funky graphics
drivers?

Would love to get to the bottom of this.

Colin

"Tim"
wrote in message ...
I've had this happen too... if you right-click on it you get
the short-cut
menu as if it was a toolbar area (i did anyway). whatever
macros i was
running at the time (can't remember) would NOT have been
related to either
toolbars or group/outlining (at least, not intentionally!).

it would be great if someone could shed some light.

cheers,

tim

"John Martin" wrote in
message
...
Tom, no little buttons, am not turning grouping or
outlining on. The area of the screen that becomes obscured
is a solid gray color about 2 inches wide by the height of
the worksheet area.

Thanks,

John


-----Original Message-----
It sounds like you are turning grouping and outlining on.

are there little buttons at the top and dot next to each
row?

--
Regards,
Tom Ogilvy

"John Martin" wrote
in message
...
On a variety of occasions while running VB code
(different
code, different applications) the left side of the
worksheet area of the screen will become hidden by a
gray
overlay of some kind.

The tool bar area and the status bar area are not
affected. The only way to clear up the problem is to
close
excel and reopen it.

This occurs even if the code runs successfully.

Any suggestions are greatly appreciated.

Excel version = Excel 2002 with SP 2 installed.


.







All times are GMT +1. The time now is 06:01 PM.

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