| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I remove a non-toolbar custom button from a sheet?
I created a custom button that I assigned to a macro and placed it into a
worksheet. Now I want to delete that button, but I cannot find anyway to delete it. Does anyone know how to select the button and delete it? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I remove a non-toolbar custom button from a sheet?
Sub DeleteAllShapes()
for each shp in ActiveSheet.Shapes shp.Delete Next End sub -- Regards, Tom Ogilvy "AaronInCarolina" wrote in message ... I created a custom button that I assigned to a macro and placed it into a worksheet. Now I want to delete that button, but I cannot find anyway to delete it. Does anyone know how to select the button and delete it? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I remove a non-toolbar custom button from a sheet?
remove any autofilter you might have in effect before running the macro.
-- Regards, Tom Ogilvy "AaronInCarolina" wrote in message ... I created a custom button that I assigned to a macro and placed it into a worksheet. Now I want to delete that button, but I cannot find anyway to delete it. Does anyone know how to select the button and delete it? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I remove a non-toolbar custom button from a sheet?
Hi
Also DataValidation arrows Sub Shapes3() 'Loop through the Shapes collection and use the Type number of the control 'Example only for the Forms controls Dim myshape As Shape For Each myshape In ActiveSheet.Shapes If myshape.Type = 8 And myshape.FormControlType < 2 Then myshape.Delete Next myshape ActiveSheet.DropDowns.Delete End Sub I have more info here about that http://www.rondebruin.nl/controlsobjectsworksheet.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Tom Ogilvy" wrote in message ... remove any autofilter you might have in effect before running the macro. -- Regards, Tom Ogilvy "AaronInCarolina" wrote in message ... I created a custom button that I assigned to a macro and placed it into a worksheet. Now I want to delete that button, but I cannot find anyway to delete it. Does anyone know how to select the button and delete it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove customized button from toolbar? | Excel Discussion (Misc queries) | |||
| How to remove unwanted custom toolbar | Excel Discussion (Misc queries) | |||
| Custom toolbar button icons | Excel Discussion (Misc queries) | |||
| Delete a custom button by holding down the ALT key and dragging the button off the toolbar | Excel Programming | |||
| Remove Save Button from toolbar | Excel Programming | |||
Hybrid Mode
