XLplus Add-On: Work with Shapes
This tool supports you selecting or deleting all or a part of all shape objects of the active worksheet.
The following types of shapes are available:
| msoAutoShape |
Auto Shapes, i.e. rectangle, circle, rhombus, star and more |
| msoCallout |
Callouts, a special type of auto shapes |
| msoChart |
Charts |
| msoDiagram |
Flowchart objects |
| msoEmbeddedOLEObject |
Embedded OLE Objects, i.e. a picture or a video |
| msoFormControl |
Form Control Elements, i.e. a checkbox or a listbox |
| msoFreeform |
Lines freely drawn |
| msoGroup |
Grouped shapes |
| msoLine |
Lines having a fixed start and endpoint |
| msoLinkedOLEObject |
Linked OLE Objects, i.e. a Word file or a picture |
| msoOLEControlObject |
OLE Control Objects, i.e. Checkbox or listbox |
| msoPicture |
Picture |
| msoTextBox |
Text Box created by the drawing toolbar |
| msoTextEffect |
TextEffect Objects, created by Word Art |
Once you have selected all shapes of a desired type, perform an action with all of them at once, i.e. assign a certain background color or copy them to the clipboard. Alternatively use this tool to clean a spreadsheet from objects no longer needed by using Delete.
See also:
XLplus Delete Hyperlinks
XLplus Save All Workbooks
XLplus Close Workbooks
XLplus Delete Worksheets
XLplus Insert Sheets
XLplus Show Hidden Sheets
XLplus Hide Sheets
XLplus Manage Hidden Cells
XLplus Sort Sheets
XLplus View Special Cells
XLplus Number To Text
XLplus Rename Worksheets
XLplus Convert Characters
XLplus Regional Settings
XLplus Set Zoomfactor of Worksheets
XLplus Goto Sheet