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.

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.

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.


.

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,

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.


.

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.


.

.

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.


.

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.


.