hi
with this marco i add Oval shape to sheet
i want add shadow to shape and check mark "Dont Move or Size with cell"
with this marco i add Oval shape to sheet
Code:
Sub OvalClick_()
Dim i As Long
i = Range("N2")
ActiveSheet.Shapes.AddShape(msoShapeOval, 480, 170, 200, 200).Select
Selection.ShapeRange.Fill.Visible = msoFalse
Selection.ShapeRange.Line.DashStyle = msoLineSolid
Selection.ShapeRange.Line.Weight = 2.5
Selection.ShapeRange.Line.foreColor.RGB = RGB(48, 48, 48)
Selection.Name = "Oval " & i
Range("N2").Value = Range("N2").Value + 1
End Sub
i want add shadow to shape and check mark "Dont Move or Size with cell"