EXCEL – Delete a Command Button On a Worksheet Using VBA

stevejoyce-fwl2yhq1 · 2010-07-05T19:27:00.000Z

After using VBA to add a worksheet (see previous post) I want to add a line to the code to delete the Command Button on the copied sheet (the button will remain on the “template”).

Can someone help me as to how this is done, please?

Regards

previoustoolboxuser · 2018-08-21T05:55:42.000Z

Theres a newer thread related to this topic! Check it out here: Unable to Delete Specific Buttons

stevejoyce-fwl2yhq1 · 2010-07-05T22:05:00.000Z

Wow, well done Michael.

Is any question too hard for you?

With thanks,
Steve

previoustoolboxuser · 2010-07-05T20:33:00.000Z

Steve,

The secret is that a commandbutton is a “shape” on a worksheet. Therefore, you need to delete it from the Shapes collection:
…
ActiveSheet.Shapes(“CommandButton1”).Delete
…

Michael S. Meyers-Jouan

previoustoolboxuser · 2012-02-17T05:11:00.000Z

Thanks for sharing secret!