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
|