How to activate a different chart

[chuckchuckit]

I have 2 charts on an active page. I know this is the code to activate most recently created chart:

ActiveSheet.ChartObjects(ActiveSheet.ChartObjects.Count).Activate

It happens to be chart #2. So how would I activate chart #1?

I am trying to avoid using the .Select as other programs might unselect.

Would there be problems running code on an activated chart if the "escape key" gets pushed? Does the active chart then become no longer active when push escape?

Can "With" procedures be use to make chart changes without activating the chart?

Thanks.

Chuck

 

[AlphaFrog]

It happens to be chart #2. So how would I activate chart #1?

ActiveSheet.ChartObjects([COLOR="Red"]1[/COLOR]).Activate

Would there be problems running code on an activated chart if the "escape key" gets pushed? Does the active chart then become no longer active when push escape?

No. It remains active until something else is activated.

Can "With" procedures be use to make chart changes without activating the chart?

Absolutely.


Here's a site you might find useful...
Quick Excel Chart VBA Examples

 

[chuckchuckit]

AlphaFrog,

Yep, that worked. And that link could keep a person busier than a squirrel in October.

Appreciate it. I saw Some Peltier stuff, but not that link with all the code. Very helpful.

Thanks.

Chuck