ChartSheet Deselect VBA

[gmooney]

I would like a way via this VBA code to deselect the ChartSheet (Segment & Brand) WITHOUT using the SendKeys command.

Private Sub SB()


Application.ScreenUpdating = True
Sheets("Segment & Brand").Select
Application.ScreenUpdating = True
End Sub

Any thoughts?

 

[Jon Peltier]

You mean you just want the chart area not to be selected? ActiveChart.Deselect used to do this, back in Excel 2003 and earlier, but now it has no effect, and it has apparently been deprecated. That is, it's only visible in the Object Browser if you show hidden members. I no longer know how to deselect the chart using VBA.

 

[gmooney]

Hi Jon,

Big fan of your work!

Yes it appears that this no longer works with Excel 2010 and beyond! Seems like we are going backwards, not forwards! Anyone else have any ideas?