Nov 24, 2003 #1 ChrisBurch IS-IT--Management Joined Jul 3, 2001 Messages 184 Location AU How do I Delete (destroy) an Excel command button programmatically? Chris It worked yesterday. It doesn't work today. That's Windows!
How do I Delete (destroy) an Excel command button programmatically? Chris It worked yesterday. It doesn't work today. That's Windows!
Nov 24, 2003 #2 TonyJollans Programmer Joined Dec 18, 2002 Messages 7,186 Location GB Hi Chris, The options depend a bit on what type of button it is but they should all be members of the Sheet's Shapes collections, so .. Code: Sheet1.Shapes("CommandButton1").Delete .. or something similar should do it. Enjoy, Tony Upvote 0 Downvote
Hi Chris, The options depend a bit on what type of button it is but they should all be members of the Sheet's Shapes collections, so .. Code: Sheet1.Shapes("CommandButton1").Delete .. or something similar should do it. Enjoy, Tony