Microsoft's help page on shape objects also has some interesting bits on this topic, namely the following:Īn ActiveX control on a sheet has two names: the name of the shape that contains the control, which you can see in the Name box when you view the sheet, and the code name for the control, which you can see in the cell to the right of (Name) in the Properties window. Siddarth's comment included the helpful detail which was essentially the solution to my problem. This was the code that worked: Sub del_button() If InStr(, 'CommandButton') > 0 And InStr(, '_') What name should I specify in the code then, if the one I used isn't correct? Or do I have to use something else entirely? I added an if-condition to exclude 'good' buttons with names set in snake case (hence '_'), i. The code I am using is based on used Gareth's code in Word vba delete button not working => Apparently I am not using the right name to address the button. I even tried to delete just one button with ActiveSheet.Shapes('CommandButton1').Delete, but that line results in an error window with a text saying something like 'An item with that name wasn't found.'. I see the button in front of me and its properties window looks like this. I cannot figure out why this code does not 'detect' the activex button (created with Siddarth's help in here: How to rename a newly created ActiveX button?).

Remove activex controls word