How to set default line thickness for drawing an arrow or line

[luv2glyd]

If I want to draw a line or an arrow, the default thickness is set to 0.75, and the default color is blue. Is there a way to change these?

Thanks

[JLGWhiz]

Please Login or Register  to view this content.

If it is a shape line. If a Chart object then you use the parent of the line instead of Shapes.

[luv2glyd]

Please Login or Register  to view this content.

If it is a shape line. If a Chart object then you use the parent of the line instead of Shapes.

Great! That works well for formatting the line after it has been drawn (it is a 'shape' line). Is there anyway to impose this formatting prior to the line being drawn so that it is drawn at a pre-determined thickness?

[JLGWhiz]

Great! That works well for formatting the line after it has been drawn (it is a 'shape' line). Is there anyway to impose this formatting prior to the line being drawn so that it is drawn at a pre-determined thickness?

You do it when you create the shape or line.
example:

Please Login or Register  to view this content.

Syntax might need some clean-up, but this should give you the gerneral idea. Open your vb editor, click on help and in the search box type 'Shapes.Add' to get more details.

[luv2glyd]

I'm I actually have to hand-draw the shapes to take notes on what's recorded in the workbook, so can't use preset parameters for shape dimensions, just wanted to see if the default line thickness can be changed before I hand draw lines, arrows....

[JLGWhiz]

I'm I actually have to hand-draw the shapes to take notes on what's recorded in the workbook, so can't use preset parameters for shape dimensions, just wanted to see if the default line thickness can be changed before I hand draw lines, arrows....

I think you have to use the Format Shape method after the shape is drawn in Excel. But if you are going to use more than one of the same shape, you can copy the first one after you set the line width and then drag the copy to where you want it and adjust the length by dragging the node points on either end.

[luv2glyd]

Ok. Sounds that good. Thanks a lot for your help.

[JLGWhiz]

Ok. Sounds that good. Thanks a lot for your help.

You are welcome.
regards, JLG