View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bmurphy@xlrotor.com is offline
external usenet poster
 
Posts: 49
Default 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