select a chart without the selector handles showing?

M

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 nadles

markers show?


Kind regards, Mark
 
T

Tushar Mehta

One almost never needs to select a chart (or any other object for that
matter). Set a variable to the chart in question and use that variable.

dim aChart as chart
set aChart=activesheet.chartobjects(1).chart
msgbox achart.seriescollection.count

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005
 
Top