Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting Drawing Object By Name | Excel Programming | |||
Floating Drawing Object | Excel Programming | |||
Drawing Object in a Userform | Excel Programming | |||
Drawing Object | Excel Programming | |||
Drawing object references | Excel Programming |