Keep a shape from looking like it's selected

Bagharmin

Board Regular
Joined
Nov 22, 2010
Messages
167
How can I keep a selected shape from looking like it's selected? I've created an arrow shape:

Code:
ActiveSheet.Shapes.AddConnector(msoConnectorStraight, XStart, YStart, XEnd, YEnd). _
        Select
    Selection.ShapeRange.Line.EndArrowheadStyle = msoArrowheadOpen
    Selection.ShapeRange.Line.ForeColor.ObjectThemeColor = msoThemeColorText1
I want to manipulate it either without having to select it or by having Excel not show those selection marks (the little circles that appear at both ends of the arrow when you click on it). Any tips would be appreciated.

Many thanks.
 

RickXL

MrExcel MVP
Joined
Sep 9, 2013
Messages
4,314
Hi,

You could assign a macro to the arrow. The macro does not have to do anything. For example:
Code:
Sub DoNothing()

End Sub
 

Forum statistics

Threads
1,085,505
Messages
5,384,073
Members
401,881
Latest member
Dato

Some videos you may like

This Week's Hot Topics

Top