excel 2007 chart programming tip
 

I have found that when a chart on a worksheet is selected or activated
with a VBA statement, it doesn't "look" like it is selected, even
though it is.

To make it look the same as when you click on it with the mouse, the
following statements seem to do the trick.

Range("A1").Copy
Application.CutCopyMode = False

Cheers,

Brian Murphy