Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to delete shapes/objects from a preselected area? I am trying
to use the following macro, but it takes a long time. It also has the problem as you can't tell which object is selected when the dialog box is open. There are too many objects to manually select and delete. Tim Sub delete_objects_in_an_area() Dim shp As Shape For Each shp In ActiveSheet.Shapes shp.Select 'can't determine which shape is selected 'ActiveSheet.activeShape.Select 'need to select shape first so I know whether to delete or not response = MsgBox("Delete shape?", vbYesNoCancel + vbCritical + vbDefaultButton2) If response = vbYes Then shp.Delete ElseIf response = vbCancel Then Exit Sub End If Next end su |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deleting shapes in an area | Excel Programming | |||
Deleting shapes/objects from a preselected area | Excel Programming | |||
Trying To Store Shapes/Objects to an array ?? | Excel Programming | |||
Trying To Store Shapes/Objects to an array ?? | Excel Programming | |||
Selecting drawing objects or shapes in a macro | Excel Programming |