View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jedihe jedihe is offline
external usenet poster
 
Posts: 1
Default Unselect shaperange object after drawing it with VBA?

I use VBA to draw lines and dots on a control chart that consists of cells
border and color formats.

When the code finishes, the last thing drawn is still "selected". So if I
say, hit an arrow key, that dot or line is moved. I don't want that. I have
12 other people using this chart and I need predictable behavior.

I tried adding to the end of the sub "Activecell.offset(0,1).activate" or
"select" but the dot is still selected (ergo affected by the next
keystrokes).

If you hit the {ESC} key in Excel, problem solved, so you would think ...

SendKeys "{ESC}" ... once or twice would do the trick, right? Nope, doesn't
work.

Help! Please, help. This is driving me nuts. -JayH