Chart Deselect in 2007
 

Hi,

I found threads speaking about almost the same problem but with a big
difference: it involved an embedded chart and I'm using a chart sheet.

So here is my problem:
I'm trying to deselect a chartarea in a chart sheet.
For this, I was using the following lines in Excel 2003 and earlier which
worked fine:
MyChart.ChartArea.Select
MyChart.Deselect

For some reason, this no longer works in Excel 2007 and yet pressing ESC or
clicking on the ugly blue/silver/black border (depending on the color scheme)
around the chart does the trick but obviously recording a macro does not
record any event for these actions.
So I was wondering... is this a known issue, and is there another way to
deselect the chart programmatically (other than using SendKeys "{ESC}") ?

Thanks.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200804/1

Chart Deselect in 2007
 

I've validated that this is an issue. I don't know whether it's a "known"
issue, but I've reported it as a bug in hopes of getting it onto the Redmond
radar screen.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"lorddah via OfficeKB.com" <u10761@uwe wrote in message
news:8326b72d2e422@uwe...
Hi,

I found threads speaking about almost the same problem but with a big
difference: it involved an embedded chart and I'm using a chart sheet.

So here is my problem:
I'm trying to deselect a chartarea in a chart sheet.
For this, I was using the following lines in Excel 2003 and earlier which
worked fine:
MyChart.ChartArea.Select
MyChart.Deselect

For some reason, this no longer works in Excel 2007 and yet pressing ESC
or
clicking on the ugly blue/silver/black border (depending on the color
scheme)
around the chart does the trick but obviously recording a macro does not
record any event for these actions.
So I was wondering... is this a known issue, and is there another way to
deselect the chart programmatically (other than using SendKeys "{ESC}") ?

Thanks.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200804/1