Removing focus from chart

[bd528]

Hi,

I have a dashboard where I select a chart type, and then the selected chart is built via VBA.

Although the source data changes, the code to create each chart is pretty much identical, apart from the chart's properties.

After the chart is created, I'd prefer it if none of the charts elements were selected. To achieve this I'm using :-

range("A1").select

In all but 2 cases, this works, but for those 2 charts the chart's labels remain selected even after the code above is stepped over.

Can anyone suggest a way to remove focus from my chart in every case once they have been fully created?

Many thanks.