Deselect Chart in 2007

[ErikJan]

Need to deselect a chart on a chart-sheet in Excel 2007. Just clicking anywhere with the mouse does it. How do I do this in VBA?

If I record the 'click anywhere' action, I get nothing captured in VBA-code. Setting "Activewindow.Visible=False"is a known bug in 2007 and does not work. I tried ActiveChart.Deselect but that doesn't work too.

I can write code to prevent the chart from being selected, but I'd like my code to fix this anyway; maybe the user selected the chart manually, then I want to unselect.

Any ideas?

This works but I don't like it... SendKeys "{ESC}", TRUE

[HansV]

Clicking "anywhere" with the mouse usually results in selecting something - if not a series or axis, then the chart's plot area or chart area. What exactly do you mean by deselect?

[ErikJan]

When I click outside the chart-area all gets deselected.

Deselected.PNG

Selected.PNG

[HansV]

Thanks. There doesn't seem to be any support for this, so the only thing I can come up with is the rather lame

Code: Select all

    ActiveChart.ChartArea.Select
    SendKeys "{ESC}"

Remark: this only works when run from Excel. If you run this from the Visual Basic Editor, the keystroke is sent to the VBE instead of to the chart.

[ErikJan]

See my original post... it's there (I found that and had updated the post before the first answer already) :-)

[HansV]

Sorry, I hadn't noticed the update. The screenshots in your reply had caused the original post to scroll off the screen.

I don't like SendKeys either, but I can't think of or find a better way.

[rory]

Does it work if you protect and then unprotect the chart?

[ErikJan]

Does it work if you protect and then unprotect the chart?

Very interesting... that actually works! Thank you, I would have never figured that one out