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
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
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
[email protected]HIS
"Mark Stephens" <[email protected]> wrote in message
news:[email protected]...
>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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks