List Shapes

Location on ribbon: Tab DVD Addin → Group Graphics → Menu Shape Menu

Command ID: btnListShapes

What it does

This command walks every shape on the active sheet and writes each shape's name onto the worksheet, one per row, starting at the cell you have selected.

Getting the names out is the first step for any bulk shape work: building a mapping table to colour shapes by progress, preparing a rename table, or simply checking whether a layout pasted into Excel is missing a marker.

How to use

1. Open the sheet holding the shapes (the command reads the active sheet only).
2. Select an empty starting cell — the list runs downwards from there.
3. Go to tab DVD Addin → group Graphics → menu Shape Menu → click List Shapes.
4. The add-in writes the shape names into consecutive cells down the column, beginning at the selected cell.
5. When it finishes, a toast reports "Listed N shapes".
6. If no cell is selected (for example a shape or chart is selected instead), the prompt "Please select a starting cell" appears.

Example

Sheet LAYOUT holds 24 blocks representing construction zones. Select the empty cell K5 and click List Shapes:

	K
5	BAY_A1
6	BAY_A2
7	BAY_B1
8	BAY_B2
…	…

From this column, add column L computing a colour code from progress and run Color Shapes to repaint the whole layout.

Notes

• The list contains shape names only; position and size are not written out — use the Get Position command when you need coordinates.
• The command overwrites existing content in the cells below the starting cell without asking, so pick an empty area.
• Every shape on the sheet is listed, including buttons, inserted pictures and text boxes; there is no filtering by type.
• Hold ESC to stop midway; the names already written are kept.
• The write cannot be undone with Ctrl + Z.

Related

• Rename Shapes — use this list as the "old name" column of a bulk rename table.
• Color Shapes — map shape names to colour codes for progress-driven recolouring.
• Get Position — read the coordinates of the shapes named in the list you just produced.