Spyren

Sub DelButtons()

Dim btn As Button

For Each btn In Sheet1.Buttons
btn.Delete
Next btn

End Sub

The Button data type is a deprecated object (I think they want you to use
the Shape object), but it's the best for doing this.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"SPYREN" wrote in message
...
From the Forms toolbar

"Dick Kusleika" wrote:

Spyren

Buttons from the Forms toolbar or the Control Toolbox?

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"SPYREN" wrote in message
...
Greetings,

Can someone tell me how to remove ALL the buttons created in a
worksheet
without knowing the assigned number of those buttons when they were
created.
The number of buttons in the worksheet always varies.

Thank you in advance for your help.