List shapes and buttons
xlide_list_shapesList shapes on a worksheet's drawing layer—buttons, controls, pictures—with covered cells and assigned macros to locate startup actions or identify procedures before renaming a Sub.
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 and, where it has one, the macro a click runs. 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.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | One worksheet. Empty lists every sheet's shapes. | |
| file_path | Yes | Absolute path to the Excel file. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||