how do you hide the circle. It is called oval1

ActiveSheet.Shapes("oval1").Visible = False

The next thing you'll probably need to know is how to deal with multiple
shapes. The following should give you some ideas.

Sub AllShapes()
Dim shp As Shape
For Each shp In ActiveSheet.Shapes
MsgBox shp.Name
Next shp
End Sub



Regards,
Vic Eldridge


"cdclayton" wrote:

Thanks for the replies and sorry in being so long in my response but
how do you hide the circle. It is called oval1

Thanks,

Charles D Clayton Jr