List shapes and buttons
xlide_list_shapesLists Excel worksheet drawing-layer shapes—buttons, controls, pictures, charts—with covered cells, positions, linked values, and click macros to map how a workbook starts before VBA edits.
Instructions
Lists what sits on a worksheet's drawing layer: buttons, form controls, AutoShapes, text boxes, pictures, charts and groups, each with the cells it covers, its position in points and, where it has one, the macro a click runs. A form control also carries what it holds: a check box's state, a list's chosen item, a spinner's value and bounds, the cell it is linked to. Call it when asked how a workbook is started, or before renaming a Sub: a button's OnAction names a procedure and nothing rewrites it. ActiveX controls are listed but have no macro; their code is event procedures in the sheet's module. For a crowded sheet, use sheet with offset and next_offset to read later shapes.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | One worksheet. Empty lists every sheet's shapes. | |
| offset | No | Skip this many shapes on one sheet. | |
| file_path | Yes | Absolute path to the Excel file. | |
| max_results | No | Return at most this many per sheet. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||