Automatic Button Delition From Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Spyren

Buttons from the Forms toolbar or the Control Toolbox?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Specific Worksheet Using Button Form Control in Excel 0
Excel Macros to zip a file 0
How to enumerate buttons on user form 2
Remove buttons from worksheet programmatically 1
Userform to Select what worksheets to print 1
Copying a worksheet with macro buttons on it 1
Sorting one worksheet from another worksheet 3
create command buttons using vba 10

Back
Top