Remove buttons from workbook

  • Thread starter Thread starter nir020
  • Start date Start date
N

nir020

I have a spradsheet which has about 100 buttons in it, is there some code
that will search through the workbook and remove all the buttons without me
having to specify their names?

Thanks

Nick
 
Try the below code which will work on the activesheet...

Activesheet.Drawingobjects.Delete

If this post helps click Yes
 
You can remove all buttons of the Forms variety by:

Sub ButtonKiller()
ActiveSheet.Buttons.Delete
End Sub

Controls buttons are a different story.
 

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

Buttons re-assigned themselves to the right macro name but in Book 1
closing another file by code causes failure to run workbook activate event 2
Unhide sheet 2
Exporting Worksheets from a workbook and saving them as a .prn file 1
Macro code for clicking on Command Button in another workbook 7
Opening a list of Excel files and run a macro in each 17
remove button 8
Command button naming issue 1

Back
Top