I am trying to revise a few properties of an Option Button I have on my worksheet. I'm trying this:
Dim shp as shape
Set shp = ActiveSheet.Shapes(Selection.Name)
With shp.OLEFormat.Object
.Object.Caption = "2015"
.Name = "Y2015"
.Enabled = False
End With
All is successful except the Name. I've tried putting ".Object" in front of ".Name" to no avail. It remains what it was. Any ideas. Thank you so much.
Dim shp as shape
Set shp = ActiveSheet.Shapes(Selection.Name)
With shp.OLEFormat.Object
.Object.Caption = "2015"
.Name = "Y2015"
.Enabled = False
End With
All is successful except the Name. I've tried putting ".Object" in front of ".Name" to no avail. It remains what it was. Any ideas. Thank you so much.