Excel: Changing the Option Button Name (not Caption)


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.


This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of October 01, 2014.


For more resources for Microsoft Excel