HI
This code deletes all the circles in sheet
I want when I press the button deletes only circle in the active cell
Thanks
This code deletes all the circles in sheet
HTML:
Sub RemoveCircles1()
Dim shp As Shape, D As Integer
For Each shp In ActiveSheet.Shapes
If shp.AutoShapeType = msoShapeOval Then shp.Delete
Next shp
End Sub
Thanks