When I add a command button using VBA, the button has no properties option in the right-click context menu.
I record myself creating a command button, then play back the recording, and there's no properties option. Can anyone explain this?
How do I access the properties menu of a command button added using VBA?
I record myself creating a command button, then play back the recording, and there's no properties option. Can anyone explain this?
How do I access the properties menu of a command button added using VBA?
Code:
ActiveSheet.OLEObjects.Add(ClassType:="Forms.CommandButton.1", Link:=False _
, DisplayAsIcon:=False, Left:=381, Top:=157.5, Width:=54.75, Height:= _
41.25).Select