Can you select a chart but not see it's selected?

[Mark Stephens]

I thought maybe

Application.Screenupdating = false

may do it but no.

Is it possible does anyone know to select your chart but not have the handle
markers show?

Kind regards, Mark

 

[Nick Hodge]

Mark

Most actions that can be taken on 'ActiveChart' can be taken without using
that object, here for example is some code which removes the legend from an
embedded chart (Chart 2) on sheet2 without selecting it. By setting a chart
object variable I can just use this each time I want to do something with
this chart.

Sub test()
Dim myChart As ChartObject
Set myChart = Worksheets("Sheet2").ChartObjects("Chart 2")
myChart.Chart.HasLegend = False
End Sub


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)