Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove buttons from workbook
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove buttons from workbook
Try the below code which will work on the activesheet...
Activesheet.Drawingobjects.Delete If this post helps click Yes --------------- Jacob Skaria "nir020" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove buttons from workbook
You can remove all buttons of the Forms variety by:
Sub ButtonKiller() ActiveSheet.Buttons.Delete End Sub Controls buttons are a different story. -- Gary''s Student - gsnu200860 "nir020" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove buttons from workbook
See also
http://www.rondebruin.nl/controlsobjectsworksheet.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gary''s Student" wrote in message ... You can remove all buttons of the Forms variety by: Sub ButtonKiller() ActiveSheet.Buttons.Delete End Sub Controls buttons are a different story. -- Gary''s Student - gsnu200860 "nir020" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove buttons from worksheet programmatically | Excel Programming | |||
Need VBA to remove command buttons | Excel Programming | |||
Add and remove toolbar custom buttons | Excel Programming | |||
remove multiple option buttons at one time | Excel Discussion (Misc queries) | |||
Disable 'Add or Remove buttons' functionality on a toolbar | Excel Programming |