I would like to request please modify the below macro. The below macro create a line (shape), in all sheets.
If it once created (or it already exist) in all sheets then it wont create again.
Sub CrtLine()
Dim StLnShape As Shape
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
' it Create Line (Shape)
Set StLnShape = ws.Shapes.AddLine(258, 163.5, 340, 163.5)
With StLnShape
.Name = "smuneeb line"
.Line.EndArrowheadStyle = msoArrowheadNone
.Line.Weight = 1#
.Line.DashStyle = msoLineSolid
.Line.ForeColor.SchemeColor = 0
End With
Next ws
End Sub
